> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-ai-sql-walkthroughs.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

# Raycast Extension

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-ai-sql-walkthroughs/Bj1EoTflf_jG6N_3/images/raycast-search-connections.png?fit=max&auto=format&n=Bj1EoTflf_jG6N_3&q=85&s=368ef7bba711b7ae23ae5b9610eb0401" 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-ai-sql-walkthroughs/Bj1EoTflf_jG6N_3/images/raycast-search-connections-dark.png?fit=max&auto=format&n=Bj1EoTflf_jG6N_3&q=85&s=02daedb67198d7383cb087cbf7590f22" 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).