Safely inspect local dev databases with read-only schema, samples, and explain tools.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "mcp-devdb" yet — see the docs or source repo.
List all schemas, tables, and key columns in this local PostgreSQL development database, organized hierarchically.
A structured schema overview that helps the user quickly understand database organization.
Read a few sample rows from the users table, mask sensitive columns, and annotate what each column represents.
Protected sample rows that help verify table contents and column purposes.
Generate an explain plan for this query and point out possible performance risks or overly broad scans.
An explain-plan summary that helps diagnose query performance issues in development.
When joining a new project, developers can inspect PostgreSQL or SQLite schemas, table structures, and sample rows. This helps them understand the data model without modifying the database.
When a local development query becomes slow, users can inspect the explain plan to identify likely issues. The tool provides a guarded, read-only way to analyze performance in development environments.
Data analysts or developers can preview a few rows from a table while using column masking to avoid exposing sensitive information. This is useful for validating columns and building an initial understanding.
It is a safe, read-only MCP server for local development databases, supporting PostgreSQL and SQLite. It provides guarded introspection features such as schema listing, sample rows, and explain plans.
Based on the description, it is read-only and intended for safe inspection of local development databases. No write or mutation capability is mentioned in the provided information.
The description explicitly mentions column masking and query budgets to limit data exposure and query cost. For implementation details beyond that, see the source repository.
Safely explore PostgreSQL schemas, table relationships, and sample data in read-only mode.
Explore SQL schemas and run safe read-only SELECT queries.
Query and manage multiple databases with read-only access and schema inspection.
Safely explore, profile, and query SQLite and PostgreSQL databases with AI.
Safely let AI query PostgreSQL, MySQL, and SQLite in read-only mode.
Inspect PostgreSQL schemas and run read-only SQL queries through MCP tools.