WhoDB MCP
A lightweight database workspace with an MCP server: the agent reads the schema, runs queries and explores data in PostgreSQL, MySQL and more
- 5,054 ★ on the repository
- Last commit
- Apache-2.0
Broad access
Why this level
- Connects to databases and can modify data
- Runs queries with the connected database user's permissions
- AI features send content to the chosen provider
Install
- Works in
In your terminal, with SkillFoxx CLI
npx skillfoxx add mcp/whodbDetects the agents on your machine, shows the access level and pins the version.
Other ways to install
Access and checks
How we reviewBroad accessThe tool can change data, run commands or handle secrets.
- Connects to databases and can modify data
- Runs queries with the connected database user's permissions
- AI features send content to the chosen provider
This is third-party code. Review the repository files before installing.
What it does
WhoDB is a self-hosted database workspace: browse and edit data in a table grid, see a visual graph of tables and relationships, work in a query scratchpad with history and autocomplete, and import or export. It runs in the browser, as a desktop app and as a CLI, and supports PostgreSQL, MySQL, SQL Server, Oracle and other sources. For agents there is an MCP server started with npx whodb mcp serve that lets Claude, Cursor and other clients read the schema and run queries. The CLI includes agents for data analysis, query optimization and reports, and an installer can write skills, MCP config and rules into assistant directories. AI features are optional and run through a provider you choose.
Who it is for. For developers, analysts and data engineers who want database access and queries through an agent without a heavy client.
Good fit when
- You want the agent to explore the schema and run queries
- You want quick data browsing and editing without a heavy client
- You want text-to-SQL and data analysis through a chosen provider
Not a fit when
- You cannot give the agent access to a production database with write rights
- You only need the web interface without an agent connection
Example request
Show the table relationships in this database and build a query for last month's ordersMCP
- Transport
- stdio
- Authentication
- not required
Limitations
The MCP server needs database connection details, and the database user's permissions bound what it can do. AI features are optional and need your own provider, local or hosted. Change queries affect real data, so grant agent access deliberately and prefer a replica or test database.
How to disable. Remove the whodb entry from the MCP client config and stop the WhoDB container or app.
FAQ
How do I limit the agent?
Through the database user's permissions: give a read-only connection or a test database, and that bounds what the MCP server can do.
Is an AI provider required?
No. Browsing, editing and queries work without one; natural-language questions need a provider you choose.
Discussion
No questions or reviews yet.
Related
MCP serversA desktop SQL workspace with a built-in MCP server: the agent reads the schema and runs queries in the same client you already use
One MCP server for SQLite, SQL Server, PostgreSQL and MySQL: read and change data, edit schemas and export to CSV and JSON
A token-lean MCP server for PostgreSQL, MySQL, MariaDB, SQL Server and SQLite with a read-only mode
A desktop database client with an MCP server: an agent reads the schema, runs queries and triggers workflows over stdio.
A single-binary MCP server for MySQL, MariaDB, PostgreSQL and SQLite: read-only by default, with optional PII redaction
A Rust terminal database client with MCP and a JSON CLI: agents read schemas and run queries within profile permissions.
README in short
The README presents WhoDB as a lightweight self-hosted database workspace: a table grid, a visual schema graph, a query scratchpad, import and export and mock-data generation. It runs in the browser, as a desktop app, a snap and a CLI, installed via Docker or a native installer. AI features are optional and connect to Ollama, OpenAI, Anthropic, LM Studio or another compatible provider. It also ships an MCP server for assistants and a CLI with data analysis, query optimization and report agents, plus an installer for skills and config into assistant directories. Apache-2.0 licensed.