MCP Resources

Resources are read-only views of TablePro state. AI clients use them to discover what is available before calling tools. Every resource is scope-gated the same way as tools and respects the per-connection allowlist. URIs use the tablepro:// scheme inside the MCP transport. Do not confuse them with shell-level URL scheme deep links.

Discovery

Two MCP methods enumerate resources:

resources/list returns the static tablepro://connections resource plus a schema and history entry for each currently connected database.
resources/templates/list returns the URI templates for tablepro://connections/{id}/schema and tablepro://connections/{id}/history, so clients can construct a URL for any connection without waiting for it to be open.

Response envelope

resources/read wraps the resource payload in the MCP standard envelope:

{
  "contents": [
    {
      "uri": "tablepro://connections",
      "mimeType": "application/json",
      "text": "{...JSON payload below as a string...}"
    }
  ]
}

The shapes documented below are what you get after parsing text as JSON.

`tablepro://connections`

All saved connections with their current session state. Returns:

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

database reflects the active session database when connected, otherwise the saved default. type uses display casing (MySQL, PostgreSQL, SQLite, etc.). safe_mode is one of silent, alert, alertFull, safeMode, safeModeFull, readOnly. ai_policy is one of askEachTime, alwaysAllow, never. Connections with externalAccess: blocked are omitted. The envelope matches the list_connections tool. Scope: readOnly.

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

Tables and columns visible on the current connection session. Path parameter: id is the connection UUID. Returns:

{
  "tables": [
    {
      "name": "users",
      "type": "table",
      "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 }
      ]
    }
  ]
}

The response is flat: tables for the active database/schema only. To switch context, call the switch_database or switch_schema tool first. type matches the underlying TableType raw value (for example table, view). Capped at 100 tables. When more exist, the response also includes truncated: true and total_tables: <count>. For larger schemas, page through list_tables instead. Scope: readOnly.

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

Recent query history for a connection. Path parameter: id is the connection UUID. Query parameters:

Parameter	Description
`limit`	1-500. Default 50.
`search`	Full-text query string.
`date_filter`	`today`, `thisWeek`, or `thisMonth`. Anything else is treated as no date filter.

Returns:

{
  "history": [
    {
      "id": "9b2d3c5a-...",
      "query": "SELECT * FROM users WHERE active = true",
      "database_name": "app",
      "executed_at": "2026-04-26T10:14:22Z",
      "execution_time_ms": 18.4,
      "row_count": 142,
      "was_successful": true
    }
  ]
}

executed_at is an ISO 8601 timestamp. execution_time_ms is a double in milliseconds. error_message is included when was_successful is false. Scope: readOnly.

Errors

JSON-RPC code	HTTP status	Meaning
`-32602`	200	Invalid params (malformed URI, missing `uri`, bad UUID, connection not active).
`-32601`	404	Unknown resource URI (e.g. `tablepro://connections/{id}/foo`).
`-32004`	404	Resource not found in the data layer.
`-32007`	403	Token allowlist rejects the connection, or `externalAccess` is `blocked`.

Getting Started

Database Connections

Features

Customization

External API

MCP Resources

MCP Resources

Discovery

Response envelope

`tablepro://connections`

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

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

Errors

​MCP Resources

​Discovery

​Response envelope

​tablepro://connections

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

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

​Errors

MCP Resources

Discovery

Response envelope

`tablepro://connections`

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

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

Errors