home / mcp / sqlite mcp server
MCP server for reading SQLite databases
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.
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.
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.
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.
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.
Execute a SELECT SQL query on a specified SQLite database file. Returns a list of rows as dictionaries.
List all tables within a given SQLite database file.
Provide detailed schema information for a specific table, including column names, types, nullability, defaults, and primary key status.