MCP SQLite Server logo

MCP SQLite Server

by cnosuke

MCP SQLite Server is a Go-based MCP server implementation that wraps an SQLite database. It allows MCP clients to interact with SQLite via a standardized JSON‑RPC protocol.

View on GitHub

Last updated: N/A

What is MCP SQLite Server?

MCP SQLite Server is a Go-based implementation of an MCP server that provides a JSON-RPC interface to interact with an SQLite database. It enables MCP clients, such as Claude Desktop, to perform various database operations.

How to use MCP SQLite Server?

The server can be used either with Docker or by building and running the Go binary directly. Configuration is done via a YAML file or environment variables. MCP clients interact with the server by sending JSON-RPC requests to execute supported tools like creating tables, describing schemas, and executing read/write queries.

Key features of MCP SQLite Server

  • MCP Compliance (JSON-RPC interface)

  • SQLite Operations (create, describe, list, read, write)

  • Docker Support

  • Configuration via YAML or environment variables

Use cases of MCP SQLite Server

  • Integrating SQLite databases with MCP clients like Claude Desktop

  • Providing a standardized interface for database interaction

  • Enabling remote access to SQLite databases

  • Automating database tasks through MCP commands

FAQ from MCP SQLite Server

What is MCP?

MCP stands for Machine Communication Protocol. It provides a standardized way for applications to communicate with each other.

How do I configure the SQLite database path?

You can configure the SQLite database path using the SQLITE_PATH environment variable or the sqlite.path option in the config.yml file.

How do I enable debug logging?

You can enable debug logging using the DEBUG environment variable or the debug option in the config.yml file.

How do I use this server with Claude Desktop?

You can integrate the server with Claude Desktop by adding an entry to your claude_desktop_config.json file, specifying the command and arguments to run the server (either Docker or Go binary).

What MCP tools are supported?

The server supports the following MCP tools: create_table, describe_table, list_tables, read_query, and write_query.