> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-721-compare-sync.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Raycast Extension

> Install and pair the TablePro Raycast extension, and use its commands and AI tools

The TablePro Raycast extension searches connections, browses schemas and tables, and runs SQL from Raycast. It drives the GUI through the `tablepro://` URL scheme and exchanges data with the [MCP server](/external-api/mcp-tools). Requires TablePro 0.37.0 or later.

## Install

Install it from the [Raycast Store](https://www.raycast.com/ngoquocdat/tablepro), or search **TablePro** in Raycast's Store command. The source is MIT-licensed in the [Raycast extensions monorepo](https://github.com/raycast/extensions/tree/main/extensions/tablepro).

## Pair

Run **Pair with TablePro**. TablePro opens an approval sheet where you pick the scope (read-only by default), the connections the token can reach, and an optional expiry. On approve, a one-time code returns to Raycast over a deep-link callback, and the extension exchanges it for the token over localhost. Re-run the command any time to issue a fresh token; TablePro revokes the old one.

The protocol behind this is documented in [Pairing](/external-api/pairing).

## Commands

| Command              | Mode     | Description                                                                            |
| -------------------- | -------- | -------------------------------------------------------------------------------------- |
| Search Connections   | view     | Search saved connections, open one in TablePro, copy a deep link.                      |
| Open Connection      | no-view  | Open a connection by name from the root search, e.g. `Open Connection prod`.           |
| TablePro Menu Bar    | menu-bar | Recent connections and quick actions in the menu bar. Refreshes every 10 minutes.      |
| Search Schema        | view     | Browse databases and schemas across connections.                                       |
| Search Tables        | view     | Pick a connection, list its tables, copy DDL, open a table tab.                        |
| Recent Tabs          | view     | List tabs currently open in TablePro and reopen one.                                   |
| Run Query            | view     | Paste SQL, pick a connection, preview up to 50 rows or open the full grid in TablePro. |
| Search Query History | view     | Full-text search across TablePro query history.                                        |
| Pair with TablePro   | view     | Issue or refresh the API token.                                                        |

<Frame caption="Search Connections in Raycast">
  <img className="block dark:hidden" src="https://mintcdn.com/ngquct-feat-721-compare-sync/Px1jOVnHwSdgRuFN/images/raycast-search-connections.png?fit=max&auto=format&n=Px1jOVnHwSdgRuFN&q=85&s=e75fb4fb2e7bed30c06fe6407abc9d76" alt="Raycast window listing TablePro connections" width="1560" height="960" data-path="images/raycast-search-connections.png" />

  <img className="hidden dark:block" src="https://mintcdn.com/ngquct-feat-721-compare-sync/Px1jOVnHwSdgRuFN/images/raycast-search-connections-dark.png?fit=max&auto=format&n=Px1jOVnHwSdgRuFN&q=85&s=6fcbb4c94aa7094b713716d88e45594c" alt="Raycast window listing TablePro connections" width="1560" height="960" data-path="images/raycast-search-connections-dark.png" />
</Frame>

## AI tools

The extension is an AI Extension: with Raycast AI, mention `@tablepro` in a chat and Raycast picks tools from this catalog. The tools call the TablePro MCP server; see [MCP Tools](/external-api/mcp-tools) for the underlying schemas.

| Tool                     | Description                                                      |
| ------------------------ | ---------------------------------------------------------------- |
| `list-connections`       | List all saved TablePro database connections.                    |
| `list-databases`         | List database names on a connection.                             |
| `list-schemas`           | List schema names in a database.                                 |
| `list-tables`            | List tables in a connection, optionally scoped.                  |
| `describe-table`         | Column list with data types, nullability, and primary-key flags. |
| `get-table-ddl`          | The CREATE TABLE statement for a table.                          |
| `run-query`              | Execute a SQL query against a connection.                        |
| `explain-query`          | Wrap a query with EXPLAIN and return the execution plan.         |
| `open-connection-window` | Open the TablePro window for a connection.                       |
| `search-history`         | Full-text search the saved query history.                        |
| `get-connection-status`  | Live status of a connection.                                     |
| `list-recent-tabs`       | Tabs currently open in TablePro.                                 |

Write access follows the [security model](/external-api/index#security-model): a tool call cannot exceed the token's scope or the connection's external access level.

## Preferences

| Preference   | Type       | Description                                                                                                  |
| ------------ | ---------- | ------------------------------------------------------------------------------------------------------------ |
| TablePro App | App picker | Path to the TablePro app. Used to detect the install and open the app. Default `/Applications/TablePro.app`. |

## Troubleshooting

If TablePro is running but the MCP server is not, the extension opens `tablepro://integrations/start-mcp` and retries. A `401` means the token was revoked: re-run **Pair with TablePro**. For `403` access errors and other MCP failures, see [MCP client troubleshooting](/external-api/mcp-clients#troubleshooting).

## Privacy

The extension talks only to TablePro on localhost and makes no third-party network requests. Connection passwords stay in the macOS Keychain; the extension never reads them. AI tool calls go through Raycast's AI provider under Raycast's [privacy policy](https://www.raycast.com/privacy).