MCP Database Server
@cuongtl1992
About MCP Database Server
The MCP Server support your LLMs integrate with SQL Database (SQLite, SQL Server, Postgres SQL)
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"mcp-dbs": {
"command": "npx",
"args": [
"-y",
"[email protected]",
"--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": "mssql#C1t1g0@sa",
"MCP_MSSQL_ENCRYPT": "true",
"MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "true",
"MCP_MONGODB_URI": "mongodb://svc_audittrail:[email protected]:27017,dc2d-fnb-infra-02.citigo.io:27017,dc2d-fnb-infra-03.citigo.io:27017/?replicaSet=rs0",
"MCP_MONGODB_DATABASE": "hydra_kv_audit_1"
}
}
}
}Tools
4Connect to a database
Disconnect from a database
Execute a query and return results
Execute a query without returning results
Overview
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
FAQ from MCP Database Server
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.
More Databases MCP servers
mcp-server-qdrant: A Qdrant MCP server
qdrantAn official Qdrant Model Context Protocol (MCP) server implementation
mcp_mysql_server
xwb602625136Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
MongoDB Lens
furey🍃🔎 MongoDB Lens: Full Featured MCP Server for MongoDB Databases
MotherDuck's DuckDB MCP Server
motherduckdbLocal MCP server for DuckDB and MotherDuck
MCP Alchemy
runekaagaardA 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.
Comments