Advertise
MCP.so
Sign In

SQLite MCP Server

@jacksteamdev

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

jacksteamdev

About SQLite MCP Server

No overview available yet

SQLite MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-sqlite-bun-server": {
      "command": "bun",
      "args": [
        "run",
        "setup"
      ]
    }
  }
}

SQLite MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is SQLite MCP Server?

A Model Context Protocol (MCP) server that provides database interaction and business intelligence capabilities through SQLite. It enables running SQL queries, analyzing business data, and automatically generating business insight memos.

How to use SQLite MCP Server?

Install Bun, clone the repository, run bun install to install dependencies, then bun run setup to automatically configure the server in Claude Desktop (macOS: ~/Library/Application Support/Claude/claude_desktop_config.json). The server exposes tools, a dynamic resource, and a demo prompt for database operations.

Key features of SQLite MCP Server

  • Execute SELECT, INSERT, UPDATE, DELETE queries
  • Create tables with CREATE TABLE statements
  • List and describe database tables
  • Append business insights to a dynamic memo
  • Auto-updating insights memo resource (memo://insights)
  • Demonstration prompt for guided database analysis

Use cases of SQLite MCP Server

  • Run ad‑hoc SQL queries against a local SQLite database
  • Analyze business data and store discovered insights
  • Automatically generate and maintain a business insights memo
  • Walk through database analysis with a guided demo prompt

Frequently asked questions

1

What runtime does SQLite MCP Server require?

It requires [Bun](https://bun.sh) to be installed on your system.

2

Where is the SQLite database file stored?

The database file is created as `data.sqlite` in the project root directory; it is created automatically if it doesn’t exist.

3

How do I configure SQLite MCP Server for Claude Desktop?

Run `bun run setup` to automatically add the server configuration to your Claude Desktop config file (macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`).

4

What logs does the server keep?

The server writes detailed logs to `server.log` in the project root directory, including timestamps, log levels (DEBUG, INFO, WARN, ERROR, FATAL), and structured metadata.

5

What tools are provided?

Six core tools: `read-query`, `write-query`, `create-table`, `list-tables`, `describe-table`, and `append-insight`.

Comments

More Databases MCP servers

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

4

Redis MCP Server

redis

The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently

539
Advertise