Claude MarketplacesSubmit

Dbmcp

haymon-ai/dbmcp

A single-binary SQL server that connects Claude to MySQL, MariaDB, PostgreSQL, or SQLite with no runtime dependencies. Exposes tools for schema discovery (listDatabases, listTables, listViews), querying (readQuery, writeQuery), and DDL operations (createDatabase, dropTable). Ships with read-only mode by default to prevent accidental writes, plus PII redaction hooks. Supports both stdio transport for local clients like Claude Desktop and HTTP for remote setups. The cursor-based pagination and detailed table metadata responses make it practical for exploring unfamiliar schemas. Under 7MB, installed via curl script, configured through CLI flags or environment variables in your .mcp.json.

tools: 13
auth: Secret needed
transport: STDIO, HTTP
env vars: 7
last updated: Nov 11, 2026

Tools

13 tools

Public tool metadata for what this MCP can expose to an agent.

listDatabasesLists accessible databases, paginated via `cursor` / `nextCursor`. Not available for SQLite.

Lists accessible databases, paginated via `cursor` / `nextCursor`. Not available for SQLite.

No parameter schema in public metadata yet.

listTablesLists tables in a database, paginated via `cursor` / `nextCursor`.

Lists tables in a database, paginated via `cursor` / `nextCursor`.

No parameter schema in public metadata yet.

listViewsLists views in a database, paginated via `cursor` / `nextCursor`. Available on MySQL/MariaDB, PostgreSQL (`public` schema), and SQLite.

Lists views in a database, paginated via `cursor` / `nextCursor`. Available on MySQL/MariaDB, PostgreSQL (`public` schema), and SQLite.

No parameter schema in public metadata yet.

listTriggersLists user-defined triggers on tables, paginated via `cursor` / `nextCursor`. Internal constraint and foreign-key triggers are excluded.

Lists user-defined triggers on tables, paginated via `cursor` / `nextCursor`. Internal constraint and foreign-key triggers are excluded.

No parameter schema in public metadata yet.

listFunctionsLists user-defined SQL functions, paginated via `cursor` / `nextCursor`. Not available for SQLite.

Lists user-defined SQL functions, paginated via `cursor` / `nextCursor`. Not available for SQLite.

No parameter schema in public metadata yet.

listProceduresLists user-defined stored procedures, paginated via `cursor` / `nextCursor`. Not available for SQLite.

Lists user-defined stored procedures, paginated via `cursor` / `nextCursor`. Not available for SQLite.

No parameter schema in public metadata yet.

listMaterializedViewsLists materialized views in the `public` schema, paginated via `cursor` / `nextCursor`. PostgreSQL only.

Lists materialized views in the `public` schema, paginated via `cursor` / `nextCursor`. PostgreSQL only.

No parameter schema in public metadata yet.

readQueryExecutes a read-only SQL query (SELECT, SHOW, DESCRIBE, USE, EXPLAIN).

Executes a read-only SQL query (SELECT, SHOW, DESCRIBE, USE, EXPLAIN).

No parameter schema in public metadata yet.

writeQueryExecutes a write SQL query (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP). Only available when read-only mode is disabled.

Executes a write SQL query (INSERT, UPDATE, DELETE, CREATE, ALTER, DROP). Only available when read-only mode is disabled.

No parameter schema in public metadata yet.

createDatabaseCreates a database if it doesn't exist. Only available when read-only mode is disabled. Not available for SQLite.

Creates a database if it doesn't exist. Only available when read-only mode is disabled. Not available for SQLite.

No parameter schema in public metadata yet.

dropDatabaseDrops an existing database. Refuses to drop the currently connected database. Only available when read-only mode is disabled. Not available for SQLite.

Drops an existing database. Refuses to drop the currently connected database. Only available when read-only mode is disabled. Not available for SQLite.

No parameter schema in public metadata yet.

dropTableDrops a table from a database. Only available when read-only mode is disabled.

Drops a table from a database. Only available when read-only mode is disabled.

No parameter schema in public metadata yet.

explainQueryReturns the execution plan for a SQL query. Always available regardless of read-only mode.

Returns the execution plan for a SQL query. Always available regardless of read-only mode.

No parameter schema in public metadata yet.

Sponsors

Promote your product hereReach 125k+ visitors monthly Promote your product hereReach 125k+ visitors monthly

Agent CaffeineSponsoredClose your lid, come back to finished work

SnugSponsoredThe clipboard manager for the AI era Promote your product hereReach 125k+ visitors monthly

WaxSponsoredBlock anything with supervision, without erasing your iPhone Promote your product hereReach 125k+ visitors monthly

knobsSponsoredSee your site on any phone, any day, in any language

Configuration

DBMCP_TRANSPORT*default: http

MCP transport

DBMCP_HTTP_HOSTdefault: 127.0.0.1

HTTP bind host

DBMCP_HTTP_PORTdefault: 9001

HTTP bind port

DBMCP_HTTP_ALLOWED_ORIGINS

Allowed CORS origins (comma-separated)

DBMCP_HTTP_ALLOWED_HOSTS

Allowed host names (comma-separated)

DBMCP_HTTP_AUTH_TOKENsecret

Bearer token required on every request; mandatory for non-loopback binds

DBMCP_HTTP_DANGEROUSLY_ALLOW_UNAUTHENTICATEDdefault: false

Allow a non-loopback bind without DBMCP_HTTP_AUTH_TOKEN (only behind an authenticating reverse proxy)

Readme

Database MCP

A single-binary MCP server for SQL databases. Connect your AI assistant to MySQL/MariaDB, PostgreSQL, or SQLite with zero runtime dependencies.

Website · Releases

demo

Features ✨

View the full README on GitHub

Details

Repository: github.com/haymon-ai/dbmcp
Website: dbmcp.haymon.ai
Category: Databases
Package: @haymon-ai/dbmcp
Transport: STDIO, HTTP
Auth: Required
Registry: MCP registry, active

Related Databases MCP servers

1

Gnosis MCPnicholasglazer/gnosis-mcpZero-config MCP server for searchable documentation. SQLite or PostgreSQL.31stars

2

RisingWaverisingwavelabs/risingwave-mcpQuery, inspect and operate RisingWave, the PostgreSQL-compatible streaming database, from an agent.20stars

3

Memwrightbolnet/agent-memoryEmbedded memory for AI agents with SQLite, pgvector, and Neo4j graph search.0stars

4

Zotero Bridgecombjellyshen/zoterobridgeMCP Server for Zotero SQLite Database - collection, tagging, PDF reading and more.10stars

5

AdoMcpjohn0king/adomcpDatabase MCP server for schema discovery, comments, and SQL queries.4stars

6

oraclemcpmuhdur/oraclemcpEngine-free, governed Oracle Database MCP server with a fail-closed SQL guard (unofficial).4stars