Wgong Sqlite MCP Server

What wgong-sqlite-mcp-server MCP server does

The wgong-sqlite-mcp-server MCP server lets an MCP client inspect and query a SQLite database. It is designed for read-only access: the documented query tool runs SELECT statements, while the other tools expose database metadata.

Typical requests include listing the available tables, checking a table's columns and structure, previewing the first rows, counting records, filtering transactions, or calculating an average. SQLite system tables may also appear in results; the README notes that tables beginning with SQLite are system tables rather than application-created tables.

How it works

The server runs as a Python FastMCP application and reads the database location from SQLITE_DB_PATH. FastMCP commands can run the application directly, inspect its MCP interface, install it for Claude Desktop, or launch a development interface. The documented server exposes three tools and no prompts, resources, or resource templates:

• list_tables finds tables in the configured database.
• describe_table returns the structure of a selected table.
• read_query executes a SELECT query against the database.

Local testing can use FastMCP's inspector or development command. The README also describes an HTTP-based communication mode using the SSE transport and a web playground through Smithery. A locally running instance can be accessed through a localhost MCP interface; a deployed instance would use its own host and port.

Setup and configuration

Install the Python dependencies from requirements.txt, and install FastMCP if it is not already available:

pip install -r requirements.txt
pip install fastmcp

Set SQLITE_DB_PATH to the SQLite file before starting the server. For example:

SQLITE_DB_PATH=/path/to/database.db fastmcp run sqlite_explorer.py

The path must point to an existing database file. The repository recommends checking the file with ls and testing it directly with the sqlite3 command-line tool if startup or query behavior is unclear.

For Cline in VS Code, the documented configuration launches FastMCP through uv and passes SQLITE_DB_PATH in the process environment. Claude Desktop can be configured with FastMCP's installation command. Smithery playground use also requires the database path to be defined before launching the playground.

Tools and capabilities

The wgong-sqlite-mcp-server MCP server provides metadata inspection and read queries rather than database mutation. list_tables is useful as a first step when the schema is unfamiliar. describe_table helps an agent determine available columns before composing a query. read_query supports questions that can be expressed as SELECT statements, such as retrieving sample rows, filtering records, grouping counts, or calculating aggregate values.

The documented examples focus on financial data, including transactions over a specified amount and average transaction values, but the tools operate on the configured SQLite database rather than a fixed dataset.

Limitations and notes

The provided material documents SQLite support only. The server is described as read-only, so it should not be selected when an agent needs INSERT, UPDATE, DELETE, schema changes, or other write operations. The database path is supplied locally through an environment variable, and the setup examples use local filesystem paths.

The README includes example Smithery URLs and localhost inspector URLs for testing. These are deployment or session examples, not a general hosted endpoint. Confirm that the configured database exists and that the process has access to it before troubleshooting MCP connectivity.