MCP Resources

Eight URIs, all read-only, all JSON. A client reads them to find its way around before it calls a tool. Every clears the same gates a tool call does: the token’s resources:read scope, its connection allowlist, and the connection’s External Clients level and AI policy. See Scopes and gates. Reads count against the caller’s request rate like anything else.

Discovery

resources/list returns tablepro://connections, plus four entries for each connection that is currently connected and visible to this token: its schema, its tables, its databases, and its history. The list is sorted by connection name. resources/templates/list returns the seven templated URIs, so a client can build one for a connection that is not open yet. Both methods page at 50 entries with nextCursor.

The URIs

URI	Name	Payload
`tablepro://connections`	`connections`	Every saved connection this token may use, with live session state
`tablepro://connections/{connection_id}/schema`	`connection_schema`	Tables and their columns for the browsed database
`tablepro://connections/{connection_id}/databases`	`connection_databases`	`{ "databases": ["app", "analytics"] }`
`tablepro://connections/{connection_id}/schemas{?database}`	`connection_schemas`	`{ "schemas": ["public", "reporting"], "database": "app" }`
`tablepro://connections/{connection_id}/tables{?database,schema,row_counts}`	`connection_tables`	Table and view names without columns, as the `list_tables` tool returns them
`tablepro://connections/{connection_id}/tables/{table}{?database,schema}`	`table_description`	Columns, indexes, foreign keys and an approximate row count, as `describe_table` returns them
`tablepro://connections/{connection_id}/tables/{table}/ddl{?database,schema}`	`table_ddl`	The `CREATE` statement as the engine reports it, as `get_table_ddl` returns it
`tablepro://connections/{connection_id}/history{?limit,search,date_filter}`	`connection_history`	Queries recently run against this connection, newest first

{connection_id} must be a UUID; a name is -32602. On the tables URI, row_counts=true asks for approximate counts and 1 and yes also work. completion/complete fills every variable in these templates against the live schema, including table, database and schema. See Completions.

These URIs live inside the MCP transport and are not the shell-level URL scheme deep links, which happen to share the tablepro:// prefix.

Reading

resources/read needs params.uri and, in the modern era, an Mcp-Name header carrying the same URI. Every URI except tablepro://connections reads a live session, and TablePro opens the connection first if it is not open yet. A connection that will not open is -32602.

{
  "contents": [
    {
      "uri": "tablepro://connections",
      "mimeType": "application/json",
      "text": "{\"connections\":[…]}"
    }
  ]
}

The payload is a JSON string inside text. The shapes on the rest of this page are what you get after parsing it. Each read carries a private cache hint whose TTL depends on the URI; the numbers are in Cache hints.

`tablepro://connections`

{
  "connections": [
    {
      "id": "9f1f0c3e-2e3d-4b14-9c3a-1d2f4ad1f6f1",
      "name": "Production",
      "type": "PostgreSQL",
      "host": "db.example.com",
      "port": 5432,
      "database": "app",
      "is_connected": false,
      "ai_policy": "askEachTime",
      "external_access": "readOnly",
      "safe_mode": "silent"
    }
  ]
}

database is the session’s browsed database when connected, the saved default otherwise. type uses display casing (MySQL, PostgreSQL, SQLite). Connections with external_access: blocked or ai_policy: never are omitted, as are connections outside the token’s allowlist.

`tablepro://connections/{id}/schema`

{
  "database": "app",
  "tables": [
    {
      "name": "users",
      "type": "TABLE",
      "schema": "public",
      "columns": [
        { "name": "id", "data_type": "uuid", "is_nullable": false, "is_primary_key": true },
        { "name": "email", "data_type": "text", "is_nullable": false, "is_primary_key": false }
      ]
    }
  ]
}

Capped at 100 tables. Beyond that the payload also carries truncated: true and total_tables. For a larger schema use the list_tables tool, or search_schema to find one column. This is the only subscribable resource. See Subscriptions.

`tablepro://connections/{id}/history{?limit,search,date_filter}`

Parameter	Meaning
`limit`	1 to 500, default 50. Out-of-range values are clamped, not rejected.
`search`	Matched against the recorded statement text.
`date_filter`	`today`, `thisWeek` (last 7 days), or `thisMonth` (last 30 days). Anything else means no date filter.

{
  "history": [
    {
      "id": "9b2d3c5a-…",
      "query": "SELECT * FROM users WHERE active = true",
      "connection_id": "9f1f0c3e-…",
      "database_name": "app",
      "database_type": "PostgreSQL",
      "source": "editor",
      "statement_type": "select",
      "executed_at": "2026-08-20T10:14:22Z",
      "execution_time_ms": 18.4,
      "row_count": 142,
      "was_successful": true
    }
  ]
}

executed_at is ISO 8601. schema_name appears when the entry has one, and error_message when was_successful is false, redacted.

Errors

Code	Meaning
`-32602`	Missing `uri`, wrong scheme, unknown URI, connection id that is not a UUID, empty table name, or a connection that would not open
`-32020`	The `Mcp-Name` header does not match `params.uri`
`-33007`	The token’s allowlist rejects the connection, or its external access is `blocked`

Resource-not-found is -32602 rather than a code of its own; MCP Protocol lists the rest.

Overview

Drive the app

MCP

Auth

Discovery

The URIs

Reading

`tablepro://connections`

`tablepro://connections/{id}/schema`

`tablepro://connections/{id}/history{?limit,search,date_filter}`

Errors

​Discovery

​The URIs

​Reading

​tablepro://connections

​tablepro://connections/{id}/schema

​tablepro://connections/{id}/history{?limit,search,date_filter}

​Errors

Discovery

The URIs

Reading

`tablepro://connections`

`tablepro://connections/{id}/schema`

`tablepro://connections/{id}/history{?limit,search,date_filter}`

Errors