Jacksteamdev MCP Sqlite Bun Server

🚀 SQLite MCP Server

A server implementation based on the Model Context Protocol (MCP), providing database interaction and business intelligence capabilities through SQLite. The server supports running SQL queries, analyzing business data, and automatically generating business insight memos.

🚀 Quick Start

A server implementation based on the Model Context Protocol (MCP), it offers database interaction and business intelligence features via SQLite. It enables users to execute SQL queries, analyze business data, and automatically generate business insight memos.

📦 Installation

1. Install Bun if it's not already installed.
2. Clone this repository.
3. Install dependencies:

   bun install
   

4. Run the setup script to configure the server in Claude Desktop:

   bun run setup
   

The setup script will automatically add the server configuration to your Claude Desktop configuration file, which is located at:

• macOS: ~/Library/Application Support/Claude/claude_desktop_config.json

✨ Features

Resources

The server exposes a dynamic resource:

• memo://insights: A continuously updated business insight memo that aggregates all insights discovered during the analysis process.
  • Automatically updates to reflect the addition of new insights.

Prompts

The server provides a demonstration prompt:

• mcp-demo: An interactive prompt that guides users through database operations.
  • Required parameter: topic (string) - The business area to analyze.
  • Automatically generates appropriate database schemas and sample data.
  • Guides users through data analysis and insight generation.
  • Integrates with the business insight memo.

Tools

The server offers six core tools:

Query Tools

• read-query

  • Executes a SELECT query to read data from the database.
  • Input:
    • query (string): The SELECT SQL query to execute.
  • Returns: The query results as an array of objects.

• write-query

  • Executes INSERT, UPDATE, or DELETE operations.
  • Input:
    • query (string): The SQL modification query.
  • Returns: { affected_rows: number }

• create-table

  • Creates a new table in the database.
  • Input:
    • query (string): The CREATE TABLE SQL statement.
  • Returns: Confirmation that the table has been created.

Schema Tools

• list-tables

  • Gets a list of all tables in the database.
  • No input required.
  • Returns: An array of table names.

• describe-table

  • Views the schema information of a specific table.
  • Input:
    • table_name (string): The name of the table to describe.
  • Returns: An array containing column definitions (name and type).

Analysis Tools

• append-insight
  • Adds a new business insight to the memo resource.
  • Input:
    • insight (string): The business insight discovered from data analysis.
  • Returns: Confirmation that the insight has been added.
  • Triggers an update to the memo://insights resource.

🔧 Technical Details

Project Structure

• src/index.ts: The main server implementation file.
• src/logger.ts: The logging utility.
• scripts/setup.ts: The Claude Desktop configuration script.

Logging

The server maintains detailed logs at the following location:

• server.log: Located in the project root directory.
• Logs contain timestamps, log levels (DEBUG, INFO, WARN, ERROR, FATAL), and structured metadata.

Database

The SQLite database file is located at:

• data.sqlite: Located in the project root directory.
• If the file does not exist, it will be automatically created.

Available Scripts

• bun run setup: Configures the server in Claude Desktop.
• bun run lint: Runs ESLint checks.
• bun run lint:fix: Automatically fixes ESLint issues.
• bun run inspect: Runs the MCP monitor.

📄 License

This MCP server is released under the MIT License. For more details, please refer to the LICENSE file.