DB Query MCP
Q: What is db-query-mcp?
A: It's a versatile database query and export tool (MCP) that supports multiple databases, converts natural language to SQL, and offers secure read-only access by default. Key features include compatibility with ElasticSearch, MySQL, PostgreSQL, and more, plus CSV/JSON export options.
Q: How do I install db-query-mcp?
A:
- Basic install:
pip install db-query-mcp - For ElasticSearch:
pip install db-query-mcp[elasticsearch] - From GitHub:
pip install git+https://github.com/NewToolAI/db-query-mcp
Q: What databases are supported?
A:
- SQLite (built-in)
- MySQL (requires
pymysql) - PostgreSQL (requires
psycopg2-binary) - Oracle (requires
cx_Oracle) - SQL Server (requires
pyodbcorpymssql) - ElasticSearch (added in v2025-06-02)
Q: How do I configure db-query-mcp for different databases?
A: Use a JSON config file. Examples:
{
"mcpServers": {
"sqlite_db_mcp": {
"command": "db-query-mcp",
"args": [
"--db",
"sqlite",
"--uri",
"sqlite:///sqlite_company.db",
]
},
"es_db_mcp": {
"command": "db-query-mcp",
"args": [
"--db",
"elasticsearch",
"--uri",
"https://user:password@localhost:9200?index=test_data_index&ca_certs=/home/user/http_ca.crt",
]
}
}
}
Q: Is db-query-mcp secure?
A: Yes! It defaults to read-only mode to protect your data.
Q: Can I export query results?
A: Absolutely! Export data to CSV or JSON formats directly from the tool.
Q: What’s next for db-query-mcp?
A: Future updates will add support for MongoDB and GraphDatabase, aiming to become a full-stack DB query MCP.
Q: How do I contribute?
A: PRs are welcome! Check the GitHub repo:
🔗 https://github.com/NewToolAI/db-query-mcp
Q: What’s the license?
A: Apache 2.0 (open-source and free to use).
Need more help? Open an issue on GitHub! 🚀
Recommend Servers
View AllPlaywright MCP server