Agentโ™ฅ๏ธŽAge
Catalog

DB Explorer

Official

by AYUSH-148 ยท Python

Read-only SQL for PostgreSQL, MySQL and SQLite: schema, safe SELECTs, EXPLAIN, index advice

io.github.AYUSH-148/db-explorer-mcp-server (MCP Server)

This MCP server provides read-only database interactions for PostgreSQL, MySQL, and SQLite. It supports retrieving database schema, performing safe SELECT queries, running EXPLAIN, and providing index advice. Its scope is limited to read-only SQL exploration rather than data modification.

๐Ÿ› ๏ธ Key Features

  • Read-only SQL access
  • PostgreSQL support
  • MySQL support
  • SQLite support
  • Schema retrieval
  • Safe SELECT queries
  • EXPLAIN execution
  • Index advice

๐Ÿš€ Use Cases

  • Inspecting database schemas
  • Querying data via SELECT without writes
  • Analyzing query plans with EXPLAIN
  • Getting guidance on indexes for performance

โšก Developer Benefits

  • Clear separation of read-only SQL operations
  • Cross-database support (PostgreSQL, MySQL, SQLite)
  • Tooling aligned to exploration workflows (schema, SELECT, EXPLAIN, indexes)

โš ๏ธ Limitations

  • Read-only operations only
  • No data modification capabilities described

Topics

fastmcpmcp-serverstreamable-http-transportsqlalchemystdio-serverclaudemodel-context-protocolmysqlpostgresqlread-onlysqlitetext-to-sql