Advertise
MCP.so
Sign In
D

Database Intelligence Layer MCP Server

@terno-ai

Repository

Basic information

Category

Databases

Transports

stdio

Author

terno-ai

Submitted by

Navin Kumar

About Database Intelligence Layer MCP Server

TernoDBI is a database intelligence layer designed for Security and Accuracy, bridging the gap between AI Agents and Enterprise Data. It acts as a powerful standalone Model Context Protocol (MCP) server, or it can be directly embedded into your existing Django projects. Either wa

#security#accuracy

Database Intelligence Layer MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "ternodbi-query": {
      "command": "uvx",
      "args": [
        "--from",
        "terno-dbi",
        "dbi-mcp",
        "query"
      ],
      "env": {
        "TERNODBI_API_URL": "http://127.0.0.1:8376",
        "TERNODBI_API_KEY": "dbi_query_YOUR_TOKEN_HERE"
      }
    },
    "ternodbi-admin": {
      "command": "uvx",
      "args": [
        "--from",
        "terno-dbi",
        "dbi-mcp",
        "admin"
      ],
      "env": {
        "TERNODBI_API_URL": "http://127.0.0.1:8376",
        "TERNODBI_API_KEY": "dbi_admin_YOUR_TOKEN_HERE"
      }
    }
  }
}

Database Intelligence Layer MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is Database Intelligence Layer?

TernoDBI (the Database Intelligence Layer) is an MCP server that bridges AI agents and enterprise databases. It provides a secure, unified API for warehouse-scale databases while enforcing row-level security, schema enrichment, and multi-database support.

How to use Database Intelligence Layer?

Install via pip install terno-dbi, run ternodbi start, configure datasources in the admin panel, generate an access token with the CLI (ternodbi manage issue_token), then connect MCP clients like Claude Desktop using the provided JSON configuration. The server runs on 127.0.0.1:8376.

Key features of Database Intelligence Layer

  • Multi-database support: Postgres, MySQL, Snowflake, BigQuery, Databricks, Oracle, SQLite
  • Split MCP architecture: Query Server (read-only) and Admin Server (write/management)
  • Enterprise-grade security: Row-Level Security, Privacy-by-Default, SQLShield AST validation
  • LLM-ready schema enrichment with semantic metadata and statistical profiling
  • High-performance cursor-based pagination (HMAC) with ~28x speedup
  • Direct integration into existing Django projects as an embedded app

Use cases of Database Intelligence Layer

  • Secure querying of enterprise databases by AI assistants with granular access control
  • Enabling natural-language database exploration via Claude Desktop
  • Embedding into custom AI agent workflows (LangChain, LlamaIndex) using REST APIs
  • Adding intelligence to existing Django web applications through direct app integration

Frequently asked questions

1

What databases does Database Intelligence Layer support?

It supports Postgres, MySQL, Snowflake, BigQuery, Databricks, Oracle, and SQLite.

2

How does Database Intelligence Layer ensure security?

It provides Row-Level Security (SQL-based filters), privacy-by-default hiding of sensitive columns and tables, and SQLShield AST-based validation to prevent SQL injection and destructive operations.

3

Can Database Intelligence Layer be integrated into existing Django projects?

Yes, add `terno-dbi` to your environment, include `'terno_dbi.core'` in `INSTALLED_APPS`, mount its URLs, and run migrations. Then use its models and services programmatically.

4

What are the runtime requirements?

Python 3.10+ and Django 4.2+ are required. The server runs locally on `127.0.0.1:8376`.

5

How do I generate access tokens?

Use the CLI: `ternodbi manage issue_token --name "Agent Name" --type query` (or `admin` for admin tokens). Tokens can be scoped to a specific datasource and can have expiration dates.

Comments

More Databases MCP servers

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
Advertise