MCP.so
登录
D

Database Intelligence Layer

@terno-ai

代码仓库

关于 Database Intelligence Layer

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

基本信息

分类

数据库

传输方式

stdio

发布者

terno-ai

提交者

Navin Kumar

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "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"
      }
    }
  }
}

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

FAQ from Database Intelligence Layer

What databases does Database Intelligence Layer support?

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

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.

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.

What are the runtime requirements?

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

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.

评论

数据库 分类下的更多 MCP 服务器

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

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

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569