terno — Claude Code MCP server: features and setup
The terno MCP server for Claude Code connects an agent to databases and business tools. Ask it to inspect schemas or query connected data.
Apache-2.0 ★ 8 updated 2026-11-16
claude mcp add --transport http terno https://mcp.terno.ai/mcp/previewWhat terno does
terno gives an AI agent tools to inspect schemas and query connected databases. It supports Postgres, MySQL, Snowflake, BigQuery, Databricks, Oracle, and SQLite; business integrations include Google Ads, GA4, HubSpot, Salesforce, and Shopify.
SQLShield checks each query and allows SELECT statements only. Access rules apply to every request. Connect through the hosted HTTP endpoint https://mcp.terno.ai/mcp/preview; data access depends on configured sources and an access token. A self-hosted setup requires Python 3.10+ and Django 4.2+; install the package with pip install terno-dbi.
What it helps with
- inspect tables and columns in a connected database
- sample rows from a table
- run a SQL query against connected data
- connect a data source to the server
Example prompts for the agent
- Show the tables and columns in the connected database.
- Run a query on the
Customerstable and show the results. - Connect a data source to the server.
How to install terno
Platform CLI: remote server
claude mcp add --transport http terno https://mcp.terno.ai/mcp/previewPlatform CLI: remote server
codex mcp add terno --url https://mcp.terno.ai/mcp/previewConfig file
{
"mcpServers": {
"terno": {
"url": "https://mcp.terno.ai/mcp/preview"
}
}
}Config file
{
"servers": {
"terno": {
"type": "http",
"url": "https://mcp.terno.ai/mcp/preview"
}
}
}Platform CLI: remote server
gemini mcp add -t http terno https://mcp.terno.ai/mcp/previewStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about terno
How do I install terno in Claude Code?
Run claude mcp add --transport http terno https://mcp.terno.ai/mcp/preview.
What does terno do?
It connects an agent to databases through MCP, with tools for inspecting schemas, sampling rows, and running queries. SQLShield accepts SELECT statements only.
What does terno need to access data?
Claude Code connects to https://mcp.terno.ai/mcp/preview over HTTP. Queries require a configured data source and an access token.