gnomad-genetics-mcp-server: dataframe query
gnomad_dataframe_queryRun a read-only SQL SELECT against a canvas table staged by gnomad_list_gene_variants (table gene_variants) or gnomad_search_clinvar (table clinvar_variants). Use the canvas_id and table_name those tools returned to rank by allele frequency, group by consequence class, count loss-of-function variants, or filter the full set the inline preview only sampled. SELECT statements only — writes, DDL, and file/HTTP table functions are rejected by the canvas gate. Call gnomad_dataframe_describe first to discover staged table and column names.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | Read-only SQL SELECT. Reference tables by the names the staging tool returned (e.g. gene_variants). | |
| canvas_id | Yes | Canvas ID returned by gnomad_list_gene_variants or gnomad_search_clinvar. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Result rows (dynamic columns per the SQL projection), capped at the canvas row limit. | |
| error | No | Present when the call failed. Absent on success. | |
| columns | No | Column names in the result, in order. | |
| row_count | No | Number of rows the query produced (materialized count). | |
| truncated | No | True when the result exceeded the row cap and was clipped. |