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.
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.
Execute INSERT, UPDATE, or DELETE queries. Input: query (string): The SQL modification query. Returns: { affected_rows: number }.
Create new tables in the database. Input: query (string): CREATE TABLE SQL statement. Returns: Confirmation of table creation.
Get a list of all tables in the database. No input required. Returns: Array of table names.
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.
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.
No reviews yet. Be the first to review!
Sign in to join the conversation
Highlight AIOur bundler currently only supports TypeScript-based servers. Check back soon!