Skip to main content

Raycast Extension

The TablePro Raycast extension is the reference consumer of the External API. It uses the URL scheme to open the GUI and the MCP server to read schema, run queries, and search history. AI tools let Raycast Pro and Quick AI call TablePro tools directly with @tablepro mentions.

Install

  1. Open Raycast.
  2. Search for Store, then search TablePro.
  3. Click Install.
The extension is open-source under MIT, hosted at github.com/raycast/extensions/extensions/tablepro. Source contributions are welcome via the Raycast extensions monorepo.

Pair

After install, run Pair with TablePro. A form appears:
  • Client name defaults to Raycast on <hostname>.
  • Scope: readOnly, readWrite, or fullAccess. Default readOnly.
  • Allowed connections: defaults to all. Pick a subset to restrict.
  • Expiry: defaults to never. Pick a date for rotating tokens.
On submit, TablePro opens with an approval sheet. Adjust and approve. The extension stores the returned token in the macOS Keychain via Raycast’s password preference. The flow is detailed in Pairing.

Commands

Every command falls back to a clear empty state when TablePro is not running or paired. See Troubleshooting.

AI tools

If you have Raycast Pro, the extension exposes its tools to Quick AI and Raycast Chat. Mention @tablepro in a chat:
@tablepro show me users that signed up this week from production
Raycast picks the right tools, calls the MCP server, and returns the result. The catalog: The extension’s AI instructions tell the model to always describe-table before generating queries against an unknown schema, and to use Tool.Confirmation for any INSERT, UPDATE, DELETE, DROP, ALTER, or TRUNCATE.

Preferences

The token is stored in the Keychain via Raycast’s password preference type.

Troubleshooting

TablePro not installed. The extension shows an “Install TablePro” link to tablepro.app. TablePro running but MCP not started. The extension fires tablepro://integrations/start-mcp and retries. If it still fails, the message asks you to update TablePro to the latest version. No token paired. A “Pair with TablePro” call-to-action runs the pair command. Token revoked (401). The extension clears the stored token and shows the pair CTA. Connection rejected (403). The connection’s externalAccess is blocked or the token’s allowlist excludes it. Open Settings > Integrations in TablePro to inspect. Read-only error (403 Connection is read-only for external clients). The connection’s externalAccess is readOnly and the SQL is a write. Either change the connection’s external access in TablePro, or run the query in TablePro’s editor.

Privacy

The extension reads connection metadata from ~/Library/Application Support/TablePro/connections.json to build the connection picker without an MCP roundtrip. Passwords are not in that file (they live in the Keychain). The extension never reads or transmits passwords. Query results returned by Run Query stay in Raycast’s process. Raycast does not send them to a server. AI tool calls go through Raycast’s AI provider per Raycast’s privacy policy.