Advertise
MCP.so
Sign In

SQLite MCP Server

@isaacgounton

Repository

Basic information

Category

Databases

Transports

stdio

Author

isaacgounton

About SQLite MCP Server

No overview available yet

#sqlite#database#mcp-server

SQLite MCP Server config

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

{
  "mcpServers": {
    "sqlite-mcp-server": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "sqlite-mcp-server",
        "."
      ]
    }
  }
}

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?

SQLite MCP Server is a Model Context Protocol (MCP) server that provides SQLite database operations through a standardized interface. It supports in-memory and file-based storage, offering tools for SQL queries, table management, and business insights memo tracking.

How to use SQLite MCP Server?

Install dependencies and run locally with npm install and npm start, or deploy using Docker (docker build -t sqlite-mcp-server . && docker run -d ...) or Nixpacks. No environment variables are required by default; modify the database path in source code for file-based storage. Connect remote clients (e.g., n8n) via SSE at http://localhost:3000/sse with messages endpoint at http://localhost:3000/messages.

Key features of SQLite MCP Server

  • In-memory SQLite database (configurable for file-based storage)
  • SQL operations: SELECT, INSERT, UPDATE, DELETE
  • Table management: CREATE, LIST, DESCRIBE
  • Business insights memo tracking with append_insight tool
  • Docker support for easy deployment

Use cases of SQLite MCP Server

  • Quickly prototype or test SQL queries in an isolated environment
  • Manage database schemas (create, list, describe tables) via MCP tools
  • Append and track business insights as structured memos
  • Integrate a lightweight local database into AI-agent workflows

Frequently asked questions

1

What operations does SQLite MCP Server support?

It supports SELECT queries (`read_query`), data modifications (`write_query`), table creation (`create_table`), listing tables (`list_tables`), viewing schema (`describe_table`), and appending business insights (`append_insight`).

2

Is the database persistent?

By default the database runs in-memory, but you can modify the database path in `src/index.ts` to use file-based storage for persistence.

3

What runtime or dependencies are required?

Node.js and npm are needed for local development. Docker is supported for containerized deployment. No external services or environment variables are required by default.

4

How do I connect a remote client (e.g., n8n) to this server?

Connect via SSE: use the SSE URL `http://localhost:3000/sse` and the messages post endpoint `http://localhost:3000/messages`. No additional headers are required.

5

Does SQLite MCP Server require authentication or authorization?

The README does not mention any authentication or authorization mechanisms. No headers or credentials are needed for the SSE connection.

Comments

More Databases MCP servers

Local YDB MCP

astandrik

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

4

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Elasticsearch MCP Server

elastic

685

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531
Advertise