mcp-dbs

mcp-dbs

17

MCP Database Server is an implementation of the Model Context Protocol that facilitates connecting and working with multiple types of database systems. It supports SQLite, PostgreSQL, Microsoft SQL Server, and MongoDB, and comes with features for integrating with tools like Claude Desktop to execute database queries and explore schemas.

MCP Database Server

A Model Context Protocol (MCP) implementation for connecting to and working with various database systems.

Supported Databases

  • SQLite
  • PostgreSQL
  • Microsoft SQL Server
  • MongoDB

Usage

The MCP Database Server can be used in two modes: SSE Mode (Default) and STDIO Mode. By default, it runs in SSE mode on port 3001. Users can specify a custom port or use the STDIO option for communication using standard input/output.

Integration with Other Tools

It can be integrated with Claude Desktop for database connections, executing queries, and exploring schemas.

Environment Variables

Configuration of database connections can be handled using environment variables for various supported database types.

MCP Tools

  • connect-database: Connect to a database
  • disconnect-database: Disconnect from a database
  • execute-query: Execute a query and return results
  • execute-update: Execute a query without returning results

Resources

  • database-schema: Get the full database schema
  • table-schema: Get the schema for a specific table
  • tables-list: Get a list of all tables