mcp-sqlite-bun

This MCP server provides a SQLite-backed environment for running SQL queries, analyzing business data, and automatically generating business insight memos. You can interact with the server through its six core tools: read-query for SELECT operations, write-query for INSERT/UPDATE/DELETE, create-table to define new schemas, list-tables to enumerate existing tables, describe-table to inspect a table’s columns, and append-insight to add discovered insights to the business insights memo. The server also exposes a continuously updating memo at memo://insights, which aggregates insights discovered during analysis and updates as new insights are generated by the append-insight tool. To begin, configure the server via the setup script, then use the interactive mcp-demo prompt (topic) to guide database operations and generate a tailored analysis workflow for your business domain.

Prerequisites:

• Node.js or Bun installed on your system (this server uses a Bun-based setup, but it can be run under Node in this configuration)
• Git installed

Installation steps:

1. Clone the repository: git clone https://github.com/your-org/jacksteamdev-mcp-sqlite-bun-server.git
2. Navigate to the project directory: cd jacksteamdev-mcp-sqlite-bun-server
3. Install dependencies (example using Bun): bun install
4. Run the setup script to configure Claude Desktop integration: bun run setup

Note: The setup script will configure Claude Desktop to recognize this MCP server and add the necessary configuration to the Claude Desktop config file on your platform.

Tips and notes:

• The SQLite database is created at data.sqlite in the project root if it does not exist.
• Logs are written to server.log with timestamps and levels (DEBUG, INFO, WARN, ERROR, FATAL).
• The six tools (read-query, write-query, create-table, list-tables, describe-table, append-insight) are exposed for interactive database operations and memo updates.
• If you plan to run outside Claude Desktop, ensure the entry point (src/index.ts) is transpiled or executed in an environment that supports TypeScript execution, or adapt the run command to your runtime (e.g., ts-node or a built bundle).
• Environment variable DATA_PATH can be used to override the default location of the SQLite data file.