Body: <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>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-23T07:44:35.090Z
Comments.Text: 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
Comments.UserDisplayName: user438383
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-25T02:30:55.287Z
Comments.Text: 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?
Comments.UserDisplayName: M__
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-25T12:32:37.060Z
Comments.Text: 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!).
Comments.UserDisplayName: terdon
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-08-25T14:59:31.443Z
Comments.Text: 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
Comments.UserDisplayName: Ram RS
Tags: <vcf><database>
Title: Production database system for storing vcf records
ThreadText: # 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 @username_0 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 username_3 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
  
  