panasenco/mcp-sqlite
If you are the rightful owner of mcp-sqlite and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
mcp-sqlite is a model context protocol server that provides AI agents with access to SQLite databases, allowing them to retrieve data structures and execute queries without direct access to external systems.
mcp-sqlite is a tool designed to facilitate interaction between AI agents and SQLite databases. It allows AI agents to access the structure of tables and columns within a database, execute arbitrary SQL queries, and utilize predefined queries through a metadata file. This tool is particularly useful for scenarios where AI agents need to process and analyze data without having direct access to external systems. By using mcp-sqlite, AI agents can efficiently retrieve and manipulate data, making it a valuable resource for data-driven applications. Additionally, mcp-sqlite is compatible with Datasette, enabling both AI agents and human users to explore data interactively. The tool supports the creation of a metadata file that can enrich the database catalog with descriptions and canned queries, enhancing the usability and understanding of the data for AI agents.
Features
- AI agents can retrieve the structure of all tables and columns in the SQLite database using a single command.
- Metadata files can enrich the database catalog with descriptions for tables and columns.
- Canned queries in the metadata file are converted into separate MCP tools for easy execution by AI agents.
- AI agents can execute arbitrary SQL queries with the sqlite_execute command.
- Compatible with Datasette for interactive data exploration by human users.
Tools
sqlite_get_catalog
Tool to get the complete catalog of databases, tables, and columns, combined with metadata.
sqlite_execute
Tool to execute arbitrary SQL queries, returning results as HTML.
sqlite_execute_main_survivors_of_age
Tool to execute a predefined query to count survivors of a specific age.