SQLite

MCP server for reading SQLite databases

python

0

GitHub Stars

python

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "abhinavnatarajan-sqlite-reader-mcp": {
      "command": "sqlite-reader-mcp",
      "args": [
        "--paths",
        "/path/to/your/database.db",
        "/path/to/another/allowed_directory"
      ]
    }
  }
}

You can read data from SQLite databases securely and efficiently with this read-only MCP server. It lets you run SELECT queries, list tables, and inspect table schemas without modifying any data, making it ideal for auditing, reporting, or data exploration across controlled database files and directories.

How to use

Start the MCP server and connect with a FastMCP client to run read-only operations on your SQLite databases. You can execute SELECT queries, list all tables in a database, and describe the schema of any table. All queries are validated to ensure only safe read operations are performed.

How to install

Prerequisites you need before running the server.

Install the MCP server using the recommended tool installation command.

Then start the server with access paths to allowed database files or directories.

Security and usage notes

This server is strictly read-only. It only supports SELECT statements (including WITH CTES). All access to database files is restricted to absolute paths you specify at startup. Trailing semicolons are removed automatically, and multiple statements in a single query are rejected.

Examples of available operations

read_query lets you run a SELECT query on a specific SQLite database file. You can supply the file path, the query, optional parameters, and a row limit.

list_tables returns all table names in the chosen database.

describe_table provides detailed column information for a given table, including names, types, and constraints.

Available tools

read_query

Execute a SELECT SQL query on a specified SQLite database file. Returns a list of rows as dictionaries.

list_tables

List all tables within a given SQLite database file.

describe_table

Provide detailed schema information for a specific table, including column names, types, nullability, defaults, and primary key status.