Terno MCP server

Connect Claude, ChatGPT, Cursor, VS Code, or your own agent to your Terno data through the hosted MCP server.

The Terno MCP server lets AI assistants such as Claude, ChatGPT, Cursor, and your own agents query the data sources you’ve connected in Terno, through Terno’s secure query layer.

Server URL: https://mcp.terno.ai/mcp

Preview server URL: https://mcp.terno.ai/mcp/preview (adds app connectors such as Google Ads and GA4)

Before you start

A Terno AI account. You don’t need to sign up first: when you connect, Terno takes you to sign up if you don’t have an account, or to sign in if you’re signed out, and then shows the consent screen.
No data source is needed to connect. Ask your assistant to connect one and Terno gives it a link where you add the connection details in Terno. You can also add one in the app; see Connectors.

Choose your assistant

Claude claude.ai and Claude Desktop

ChatGPT Business and Enterprise workspaces

Claude Code Terminal coding agent

Cursor AI code editor

VS Code With GitHub Copilot

Windsurf AI code editor

Gemini CLI Terminal agent

Antigravity Agentic IDE

Lovable AI app builder

Your own agent Any framework that speaks MCP

Self-hosted Run the open-source TernoDBI layer

Which data sources work over MCP

Databases and warehouses connected in Terno: PostgreSQL, MySQL, Snowflake, BigQuery, Databricks, and Oracle.

Security

Read-only SQL. SQLShield checks every SQL query, and only SELECT statements are allowed.
No credentials shared with the AI. You enter connection details in Terno over an authenticated session. The assistant only receives a link to that page.
Disconnect any time. Remove the Terno connector in your AI app.

On the preview server, some app connectors such as Google Ads can also take actions. Actions need a workspace admin and an account with write access, and you can preview them with a dry run first. See Google Ads actions.