DB Query MCP

What is db-query-mcp?

db-query-mcp is an MCP tool that supports diverse database querying and exporting. It is compatible with mainstream databases (ElasticSearch, MySQL, PostgreSQL, Oracle, SQLite, etc.) and features natural language to SQL conversion, read‑only security, and data export to CSV/JSON.

How to use db-query-mcp?

Install via pip install db-query-mcp (add [elasticsearch] for ElasticSearch). Configure your MCP client with JSON, providing "command": "db-query-mcp" and "args" that include --db (e.g., sqlite, elasticsearch) and --uri (connection string). For MySQL install pymysql; for PostgreSQL install psycopg2-binary.

Key features of db-query-mcp?

• Multi‑DB support: ElasticSearch, MySQL, PostgreSQL, Oracle, SQLite