MCP Resources

Read-only resources for connections, schema, tables, and query history, with their URI templates

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.