DiscoveryFree tier

describe_table

Column-level schema for any qualified table. Returns data types, nullability, comments curated by the data team, and the cached row_count from the catalog. Run this before query_sql or before constructing geometry operations.

Use cases

Pre-flight a free-form SQL query: confirm the column you want exists and is the type you expect.
Discover the geo-join target for an aggregate dataset (e.g., ISTAT statistics joined to census polygons).
Read curated column comments before deciding whether a metric fits your analysis.
Get the cached row count to estimate query cost before scanning a 50M-row table.

Arguments

Name	Type	Required	Description
qualified	string	required	Schema-qualified table name (e.g., `commerce.overture_places_italy`).

Example request

curl

bash

curl -X POST https://mcp.qubitdata.it/mcp \
  -H "Authorization: Bearer $QUBITDATA_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "jsonrpc": "2.0",
    "id": 1,
    "method": "tools/call",
    "params": {
      "name": "describe_table",
      "arguments": {
            "qualified": "healthcare.minsalute_strutture_sanitarie"
      }
    }
  }'

Example response

JSON-RPC 2.0 result

json

{
  "jsonrpc": "2.0",
  "id": 1,
  "result": {
    "content": [
      {
        "type": "text",
        "text": "{\n  \"qualified\": \"healthcare.minsalute_strutture_sanitarie\",\n  \"row_count\": 12435,\n  \"columns\": [\n    { \"name\": \"codice_struttura\", \"type\": \"text\", \"nullable\": false, \"comment\": \"Codice univoco struttura sanitaria (Min. Salute)\" },\n    { \"name\": \"denominazione\", \"type\": \"text\", \"nullable\": false, \"comment\": null },\n    { \"name\": \"geometry\", \"type\": \"geometry(Point,4326)\", \"nullable\": true, \"comment\": \"Centroide ufficiale\" }\n  ]\n}"
      }
    ]
  }
}

Prompts to try

Drop these into Claude Desktop, Cursor, or any MCP-aware client wired to https://mcp.qubitdata.it/mcp.

Claude Desktop

Describe the table commerce.overture_places_italy — what columns can I filter on?
Cursor

Use describe_table to confirm risk.ingv_iside_terremoti has a magnitudo column before I write the SQL.
Custom MCP client

Show the schema for census_geom.istat_basi_territoriali.

Get started

Last updated: 2026-05-04