MCP.so
登录
D

Database Intelligence Layer MCP Server

@terno-ai

基本信息

分类

数据库

传输方式

stdio

作者

terno-ai

提交者

Navin Kumar

关于 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 配置

使用下面的配置,将此服务器添加到你的 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"
      }
    }
  }
}

Database Intelligence Layer MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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.

评论

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