SQLite MCP Server
Overview
A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Installation
- Install Bun if you haven't already
- Clone this repository
- Install dependencies:
- Run the setup script to configure the server in Claude Desktop:
The setup script will automatically add the server configuration to your Claude Desktop config file, located at:
- macOS:
~/Library/Application Support/Claude/claude_desktop_config.json
Components
Resources
The server exposes a single dynamic resource:
memo://insights: A continuously updated business insights memo that aggregates discovered insights during analysis
Prompts
The server provides a demonstration prompt:
mcp-demo: Interactive prompt that guides users through database operations
Tools
The server offers six core tools:
Query Tools
read-query
write-query
create-table
Schema Tools
list-tables
describe-table
Analysis Tools
append-insight
Development
Project Structure
src/index.ts: Main server implementation
src/logger.ts: Logging utility
scripts/setup.ts: Claude Desktop configuration script
Logging
The server maintains detailed logs in:
server.log: Located in the project root directory
- Logs include timestamps, log levels (DEBUG, INFO, WARN, ERROR, FATAL), and structured metadata
Database
The SQLite database file is created at:
data.sqlite: Located in the project root directory
- Created automatically if it doesn't exist
Available Scripts
bun run setup: Configure the server in Claude Desktop
bun run lint: Run ESLint checks
bun run lint:fix: Fix ESLint issues automatically
bun run inspect: Run the MCP inspector
License
This MCP server is licensed under the MIT License. See the LICENSE file for details.
SQLite MCP Server
Overview
A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Installation
- Install Bun if you haven't already
- Clone this repository
- Install dependencies:
- Run the setup script to configure the server in Claude Desktop:
The setup script will automatically add the server configuration to your Claude Desktop config file, located at:
- macOS:
~/Library/Application Support/Claude/claude_desktop_config.json
Components
Resources
The server exposes a single dynamic resource:
memo://insights: A continuously updated business insights memo that aggregates discovered insights during analysis
Prompts
The server provides a demonstration prompt:
mcp-demo: Interactive prompt that guides users through database operations
Tools
The server offers six core tools:
Query Tools
read-query
write-query
create-table
Schema Tools
list-tables
describe-table
Analysis Tools
append-insight
Development
Project Structure
src/index.ts: Main server implementation
src/logger.ts: Logging utility
scripts/setup.ts: Claude Desktop configuration script
Logging
The server maintains detailed logs in:
server.log: Located in the project root directory
- Logs include timestamps, log levels (DEBUG, INFO, WARN, ERROR, FATAL), and structured metadata
Database
The SQLite database file is created at:
data.sqlite: Located in the project root directory
- Created automatically if it doesn't exist
Available Scripts
bun run setup: Configure the server in Claude Desktop
bun run lint: Run ESLint checks
bun run lint:fix: Fix ESLint issues automatically
bun run inspect: Run the MCP inspector
License
This MCP server is licensed under the MIT License. See the LICENSE file for details.