MCP Database Server

@cuongtl1992

代码仓库

基本信息

分类

数据库

许可证

MIT

传输方式

stdio

作者

cuongtl1992

提交者

Tran Le Cuong

关于 MCP Database Server

The MCP Server support your LLMs integrate with SQL Database (SQLite, SQL Server, Postgres SQL)

MCP Database Server 配置

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

{
  "mcpServers": {
    "mcp-dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "dc2d-fnb-mssql-01.citigo.io",
        "MCP_MSSQL_PORT": "1433",
        "MCP_MSSQL_DATABASE": "HydraKiotVietShard1",
        "MCP_MSSQL_USER": "sa",
        "MCP_MSSQL_PASSWORD": "YOUR_MCP_MSSQL_PASSWORD",
        "MCP_MSSQL_ENCRYPT": "true",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "true",
        "MCP_MONGODB_URI": "mongodb://svc_audittrail:RiIWjXwzZnkaUpe@dc2d-fnb-infra-01.citigo.io:27017,dc2d-fnb-infra-02.citigo.io:27017,dc2d-fnb-infra-03.citigo.io:27017/?replicaSet=rs0",
        "MCP_MONGODB_DATABASE": "hydra_kv_audit_1"
      }
    }
  }
}

MCP Database Server 工具

Connect to a database

Disconnect from a database

Execute a query and return results

Execute a query without returning results

概览

What is MCP Database Server?

An MCP (Model Context Protocol) server for connecting to and working with SQLite, PostgreSQL, Microsoft SQL Server, and MongoDB databases. It allows AI assistants to interact with these databases through standardised tools and resources.

How to use MCP Database Server?

Install globally via npm install -g mcp-dbs or run directly with npx mcp-dbs. The server runs in SSE mode by default on port 3001; use --stdio for standard I/O mode. Configure database connections through environment variables or the connect-database tool.

Key features of MCP Database Server

Connect to and disconnect from multiple database types
Execute SQL or MongoDB queries that return results
Execute updates (INSERT, UPDATE, DELETE) without results
Retrieve full database or table schema
List all tables in a connected database

Use cases of MCP Database Server

Query databases conversationally through an AI assistant
Explore and understand unfamiliar database schemas
Perform data entry, updates, and deletions via natural language
Integrate database access into Claude Desktop workflows

常见问题

What databases does MCP Database Server support?

It supports SQLite, PostgreSQL, Microsoft SQL Server, and MongoDB.

How do I install MCP Database Server?

Install it globally with `npm install -g mcp-dbs`, or use it directly with `npx mcp-dbs`.

What transport modes are available?

Two modes: SSE (Server-Sent Events) on port 3001 by default, and STDIO mode via the `--stdio` flag.

How do I configure a database connection?

Set environment variables (e.g., `MCP_POSTGRES_HOST`, `MCP_MONGODB_URI`) before starting the server, or use the `connect-database` tool with a connection ID and database type.

Can I use MCP Database Server with Claude Desktop?

Yes. Add an entry to Claude's `mcpServers` configuration using the `node` command, the path to the server’s CLI file, the `--stdio` flag, and the required environment variables for your database.

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

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes