mcp-sqlite-bun-server

mcp-sqlite-bun-server

15
databasesknowledge_and_memory

The project is an MCP server that provides business intelligence capabilities through database interaction using SQLite. It facilitates SQL query execution, data analysis, and business insights generation, integrated with a business insights memo feature.

Overview

  • A Model Context Protocol (MCP) server implementation using SQLite.
  • Offers database interaction and business intelligence capabilities.
  • Enables running SQL queries, analyzing business data, and generating business insight memos.

Installation

  • Install Bun and clone the repository.
  • Install dependencies and configure the server in Claude Desktop.

Components

  • Resources: memo://insights for business insights.
  • Prompts: mcp-demo for database operations guidance.
  • Tools: Six core tools including read-query, write-query, create-table, list-tables, describe-table, and append-insight.

Development

  • Structure includes main server, logger, and setup script.
  • Logging in server.log with detailed information.
  • SQLite database file data.sqlite in the project root.