Dbmcp by Haymon AI is an MCP server tool built with Rust, designed to provide AI assistants with direct access to SQL databases. It supports MySQL, MariaDB, PostgreSQL, and SQLite. Dbmcp is distributed as a single binary via shell scripts for various platforms, including macOS, Linux, and Windows, or through Docker images. Cargo, Rust's package manager, also serves as an installation method. This free tool enables AI to perform schema exploration and data manipulation tasks efficiently.

What does Dbmcp connect to?

Dbmcp serves as an MCP server, primarily connecting AI assistants to SQL databases. It supports widely used database systems including MySQL, MariaDB, PostgreSQL, and SQLite. This capability allows AI agents to interact directly with these data sources, enabling tasks such as querying and schema exploration. The program is developed in Rust and distributed as a single binary, offering installation flexibility through direct downloads or Docker images.

Core features and tools

Dbmcp exposes a set of callable tools for database interaction. Schema discovery includes listDatabases, listTables, listViews, listTriggers, listFunctions, listProcedures, and listMaterializedViews. Data access is managed by readQuery and writeQuery. DDL operations include createDatabase, dropDatabase, and dropTable. Additionally, explainQuery is available. In read-only mode, write tools like writeQuery, createDatabase, dropDatabase, and dropTable are hidden, enhancing security.

Who is it for?

Dbmcp targets developers and users of AI assistants and agents who require their AI to interact with SQL databases. It is suitable for scenarios where AI needs to understand database schemas, perform data queries, or manage database structures. The tool offers PII redaction and an optional read-only mode, making it apt for secure AI integration with sensitive data. Skip this if your AI applications do not require direct SQL database interaction.

How to get started

The server authenticates using direct database credentials, such as DB_USER and DB_PASSWORD, passed as environment variables or CLI flags. Network-level access control for HTTP transport can be configured using HTTP_ALLOWED_ORIGINS and HTTP_ALLOWED_HOSTS.

Use cases

• Enabling natural language querying and schema exploration of databases by AI assistants.
• Providing secure AI access to databases with built-in PII redaction and optional read-only mode to prevent unintended write operations.
• Facilitating AI-driven database management tasks, such as creating or dropping tables, when write tools are explicitly enabled and configured.

Dbmcp offers AI assistants a direct and secure interface to various SQL databases. Developed by Haymon AI, it features extensive schema exploration, data access, and DDL capabilities, with security measures like PII redaction and read-only mode. Its distribution as a single binary or Docker image simplifies deployment for many environments. Start by configuring DB_USER and DB_PASSWORD environment variables for a secure database connection.