mcp-server-sqlite
If you are the rightful owner of mcp-server-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.
SQLite MCP Server provides database interaction and business intelligence capabilities through SQLite.
The SQLite MCP Server is a Model Context Protocol server implementation that facilitates database interaction and business intelligence through SQLite. It allows users to run SQL queries, analyze business data, and automatically generate business insight memos. The server is equipped with tools for executing SQL queries, managing database schemas, and appending business insights. It also features a dynamic resource for continuously updated business insights and a demonstration prompt to guide users through database operations and analysis.
Features
- Execute SQL queries for data manipulation and retrieval.
- Automatically generate and update business insight memos.
- Interactive prompt for guided database operations and analysis.
- Tools for managing database schemas and tables.
- Integration with business insights memo for real-time updates.
Tools
read_query
Execute SELECT query and return query results
write_query
Execute an INSERT, UPDATE, or DELETE query to return the number of affected rows
create_table
Create a new table and return confirmation information
list_tables
List all table names in the database
describe-table
View column definitions and types for a specific table
append_insight
Add new business insights memo resources
