> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-docs-fix-500-query-results.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

Searching connections, browsing schemas and running SQL happen inside the Raycast window, with no
switch to the app. Nine commands and twelve AI tools reach TablePro over the `tablepro://` scheme and
the [MCP server](/external-api/mcp-tools), after one pairing step. Needs TablePro 0.37.0 or later.

## Install

Install 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).
It talks only to TablePro on localhost; passwords stay in the macOS Keychain and the extension never
reads them.

One preference, **TablePro App**, points at the app bundle so the extension can find and launch it.
It defaults to `/Applications/TablePro.app`, so change it only for a build that lives elsewhere.

## Pair

Run **Pair with TablePro**. An approval sheet opens in TablePro where you pick the scope (read-only
to start), the connections the token may reach, and an optional expiry. Approving sends a one-time
code back to Raycast, which exchanges it for a token over localhost. [Pairing](/external-api/pairing)
documents the protocol.

Re-run the command whenever you want a fresh token. The previous one keeps working until you revoke
it in **Settings > Integrations**.

## 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, such as `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-docs-fix-500-query-results/HJY892UtvXUv1PFn/images/raycast-search-connections.png?fit=max&auto=format&n=HJY892UtvXUv1PFn&q=85&s=eb6d1c81f3ef5445c7dfe916e90db13c" 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-docs-fix-500-query-results/HJY892UtvXUv1PFn/images/raycast-search-connections-dark.png?fit=max&auto=format&n=HJY892UtvXUv1PFn&q=85&s=096d762014a8da011ad058d9bf6edac8" alt="Raycast window listing TablePro connections" width="1560" height="960" data-path="images/raycast-search-connections-dark.png" />
</Frame>

## AI tools

This is also an AI Extension: with Raycast AI, mention `@tablepro` in a chat and Raycast picks tools
from this catalog. Each one calls the MCP server, so a call cannot exceed the
[token's scope](/external-api/tokens). AI tool calls themselves go through Raycast's AI provider,
under Raycast's [privacy policy](https://www.raycast.com/privacy).

| 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.                                 |

## Troubleshooting

| Symptom                                  | What to do                                                                                                                                                                                                                                                                                        |
| ---------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Paired, but the connection list is empty | TablePro omits every connection the token cannot reach. Either the allowlist you approved left it out, or its **External Clients** level is **Blocked**. Re-pair with the connection selected, or raise the level in the [connection form's Advanced tab](/connections/connection-form#advanced). |
| Commands hang on a running TablePro      | The MCP server is stopped. The extension opens `tablepro://integrations/start-mcp` and retries on its own; give it a moment.                                                                                                                                                                      |
| `401`                                    | The token was revoked or has expired. Run **Pair with TablePro** again.                                                                                                                                                                                                                           |
| `403` and other MCP errors               | See [MCP client troubleshooting](/external-api/mcp-clients#when-it-does-not-work).                                                                                                                                                                                                                |