sqlite-mcp-server
If you are the rightful owner of sqlite-mcp-server 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.
A Model Context Protocol (MCP) server that provides comprehensive SQLite database management and analysis capabilities.
The SQLite MCP Server is designed to facilitate the management and analysis of SQLite databases through a Model Context Protocol (MCP) interface. It allows users to explore database schemas, execute queries, perform updates, and conduct statistical analyses. The server is equipped with features that enable schema exploration, data management, and data analysis, making it a versatile tool for database administrators and developers. With built-in security measures and error handling, the server ensures safe and efficient database operations. It also supports integration with platforms like Claude Desktop, enhancing its usability in various environments.
Features
- Schema Exploration: List all tables in the database, view detailed schema information for specific tables, and examine column types and constraints.
- Data Management: Execute read-only SQL queries, perform data modifications (UPDATE, INSERT, DELETE), and ensure safe execution with error handling.
- Data Analysis: Conduct basic statistical analysis (row counts, null counts, numeric stats) and detailed analysis including categorical data distributions.
Tools
query
Execute read-only SQL queries.
update_data
Perform data modifications such as INSERT and UPDATE.
analyze_table
Perform statistical analysis on table data.
