SQLite
Summary
This SQLite MCP server, developed using Bun and TypeScript, provides AI assistants with database interaction and business intelligence capabilities. It offers tools for executing SQL queries, analyzing business data, and automatically generating insights. The server integrates with Claude Desktop, leveraging a custom setup script for easy configuration. It features a dynamic resource for storing business insights, a guided demo prompt for interactive analysis, and six core tools for database operations and insight management. This implementation is particularly suited for AI-assisted business analysis, data exploration, and automated report generation, enabling use cases such as market trend analysis, performance metric tracking, and data-driven decision support.
Available Actions(6)
read-query
Execute SELECT queries to read data from the database. Input: query (string): The SELECT SQL query to execute. Returns: Query results as array of objects.
write-query
Execute INSERT, UPDATE, or DELETE queries. Input: query (string): The SQL modification query. Returns: { affected_rows: number }.
create-table
Create new tables in the database. Input: query (string): CREATE TABLE SQL statement. Returns: Confirmation of table creation.
list-tables
Get a list of all tables in the database. No input required. Returns: Array of table names.
describe-table
View schema information for a specific table. Input: table_name (string): Name of table to describe. Returns: Array of column definitions with names and types.
append-insight
Add new business insights to the memo resource. Input: insight (string): Business insight discovered from data analysis. Returns: Confirmation of insight addition. Triggers update of memo://insights resource.
社区评论
暂无评论. 成为第一个评论的人！
登录以参与讨论
