Safely explore a SQLite shop database with read-only queries and reports.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "db-mcp" yet — see the docs or source repo.
Please inspect this SQLite shop database’s tables, fields, and key relationships.
A schema overview that helps me understand the available data.
Use a read-only SQL query to list the top 10 customers by spending in the last 30 days, sorted descending.
A ranked list of customers with their spending amounts.
Give me the shop’s revenue summary, preferably using the built-in analytics reports.
Revenue summary, trends, or key metrics.
A data analyst or developer can first use schema discovery to learn the available tables, fields, and relationships. This speeds up downstream analysis and query design.
When you need customer, product, or order data, you can use read-only SQL queries to fetch results without changing the database.
Useful for product managers or operators who want quick access to built-in reports like top customers, top products, and revenue summaries.
It is an MCP tool for safely interacting with a SQLite shop database. It supports schema discovery, read-only SQL queries, and built-in analytics reports.
No. The description explicitly says it provides read-only SQL queries, so it is for viewing and analyzing data rather than writing to it.
The built-in reports mentioned in the description include top customers, top products, and revenue summaries.
Safely inspect an online store’s SQLite data with read-only analytics.
Safely explore and query SQLite databases using natural language.
Query e-commerce SQLite data safely and answer business analytics questions.
Connect AI to SQLite and query tables using natural language.
Safely query and manage SQLite databases with transactions and operation separation.
Safely explore SQLite schemas and run read-only queries with AI agents.