Query and update SQLite databases with a local LLM through MCP tools.
Copy the install command and let the AI configure it · recommended for beginners
No copy-paste install info for "MCP Database Assistant" yet — see the docs or source repo.
Connect to the current SQLite database and calculate daily order counts and revenue for the last 30 days, then return the results sorted by date ascending.
A daily summary of order counts and revenue ready for review or analysis.
Find all records where payment is completed but the order status is still 'pending', update them to 'confirmed', and first show how many records will be changed.
It first reports the affected row count, then performs the controlled update and returns the result.
List all tables in the database and describe the main columns, column types, and possible relationships for each table.
A clear overview of the database schema for understanding and follow-up queries.
Safely query and inspect local SQLite databases through a read-only MCP server.
Query databases in natural language and auto-generate and execute SQL.
Interact with SQLite via MCP for CRUD, SQL queries, and schema exploration.
Enable AI to create, manage, and query SQLite databases with required metadata.
Safely explore and query SQLite databases using natural language.
Query and manage SQLite databases using natural language through an MCP tool.