<p>I’m standing up a production bioinformatics pipeline that’ll be producing standard VCF files. I’d like to store this data in an SQL database that ingest the VCFs and allow me and my team to easily query and visualize many VCFs. Because multiple people will have access to the data, roles/permissions need to be built in. I don’t want to create this system from scratch, but it needs to be both robust and intuitive. Are there any products like this available today?</p>
<p><em>[Edit]:</em> The answers provided to <a href="https://bioinformatics.stackexchange.com/questions/15248/how-to-import-large-bed-gff-vcf-paf-sam-files-into-an-sql-database">this question</a> are on the right track, but only provide a small slice of the functionality I'm looking for. For starters, I'm looking for a hosted/managed solution; something potentially like <a href="https://www.illumina.com/products/by-type/informatics-products/basespace-sequence-hub.html" rel="nofollow noreferrer">Basespace</a>, but more user-friendly and not quite so bloated.</p>
<p>Additionally, the linked solutions are mostly about getting vcfs into a db, but don't make much headway into providing exploration/visualization tooling.</p>

CC BY-SA 4.0
2022-08-23T07:44:35.090Z
May be something useful here https://bioinformatics.stackexchange.com/questions/15248/how-to-import-large-bed-gff-vcf-paf-sam-files-into-an-sql-database
user438383
CC BY-SA 4.0
2022-08-25T02:30:55.287Z
Hi @JessimeKirk IMO it is better to ask a question focussed on a single specific issue in most cases. Maybe summarise the answer kindly provided above and focus on a Basespace type solution?
M__
CC BY-SA 4.0
2022-08-25T12:32:37.060Z
If you are open to non-free solutions, check out [VarSome Clinical](https://landing.varsome.com/varsome-clinical). (**disclaimer**: I work for the company behind this, so I am obviously not impartial, but it really is good, honest!).
terdon
CC BY-SA 4.0
2022-08-25T14:59:31.443Z
Like terdon says, you may have to go for commercial solutions if you want layman storage/visualization for VCF files. You're looking to offload bioinformatics work and no free tool can effectively replace something a human being needs to do
Ram RS
<vcf><database>
Production database system for storing vcf records
# Production database system for storing vcf records

(Asked by: username_0 on 2022-08-23)

I’m standing up a production bioinformatics pipeline that’ll be producing standard VCF files. I’d like to store this data in an SQL database that ingest the VCFs and allow me and my team to easily query and visualize many VCFs. Because multiple people will have access to the data, roles/permissions need to be built in. I don’t want to create this system from scratch, but it needs to be both robust and intuitive. Are there any products like this available today?

*[Edit]:* The answers provided to [this question](https://bioinformatics.stackexchange.com/questions/15248/how-to-import-large-bed-gff-vcf-paf-sam-files-into-an-sql-database) are on the right track, but only provide a small slice of the functionality I'm looking for. For starters, I'm looking for a hosted/managed solution; something potentially like [Basespace](https://www.illumina.com/products/by-type/informatics-products/basespace-sequence-hub.html), but more user-friendly and not quite so bloated.

Additionally, the linked solutions are mostly about getting vcfs into a db, but don't make much headway into providing exploration/visualization tooling.

**Tags:** vcf, database
> **Comments:**
> **username_1**: May be something useful here https://bioinformatics.stackexchange.com/questions/15248/how-to-import-large-bed-gff-vcf-paf-sam-files-into-an-sql-database  
> **username_2**: Hi @JessimeKirk IMO it is better to ask a question focussed on a single specific issue in most cases. Maybe summarise the answer kindly provided above and focus on a Basespace type solution?  
> **username_3**: If you are open to non-free solutions, check out [VarSome Clinical](https://landing.varsome.com/varsome-clinical). (**disclaimer**: I work for the company behind this, so I am obviously not impartial, but it really is good, honest!).  
> **username_4**: Like terdon says, you may have to go for commercial solutions if you want layman storage/visualization for VCF files. You're looking to offload bioinformatics work and no free tool can effectively replace something a human being needs to do  

---

## 0 answers

