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.
The MCP SQLite Server is a Model Context Protocol server designed to facilitate comprehensive interaction with SQLite databases, offering a range of features for database management and query execution.
The MCP SQLite Server is a robust tool for developers who need to interact with SQLite databases through a Model Context Protocol server. It supports complete CRUD operations, allowing users to create, read, update, and delete records with ease. Additionally, it provides tools for database exploration and introspection, enabling users to gain insights into the database structure and contents. The server also allows the execution of custom SQL queries, making it a versatile solution for various database management tasks. Built with the Model Context Protocol SDK and sqlite3, this server is designed to integrate seamlessly with development environments, providing a streamlined workflow for database operations.
Features
- Complete CRUD operations (Create, Read, Update, Delete)
- Database exploration and introspection
- Execute custom SQL queries
Tools
db_info
Get detailed information about the connected database.
list_tables
List all tables in the database.
get_table_schema
Get detailed information about a table's schema.
create_record
Insert a new record into a table.
read_records
Query records from a table with optional filtering.
update_records
Update records in a table that match specified conditions.
delete_records
Delete records from a table that match specified conditions.
query
Execute a custom SQL query against the connected SQLite database.
