Model Context Protocol low risk

SQLite Explorer Fastmcp

This MCP server provides read-only access to SQLite databases with query validation, table listing, and schema description, enhancing safe data exploration.

Connections & Capabilities

Connects To

GitHubSQLite

Capabilities

read

Quickstart

Install

pip install -r

Config

{
  "sqlite-explorer": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "fastmcp",
      "--with",
      "uvicorn",
      "fastmcp",
      "run",
      "/path/to/repo/sqlite_explorer.py"
    ],
    "env": {
      "SQLITE_DB_PATH": "/path/to/your/database.db"
    }
  }
}

Exposed MCP Tools (3)

safe

read_query

Executes a SELECT query on the database with safety validations and returns results as dictionaries.

Read-only operation with query validation.

safe

list_tables

Lists all available tables in the database.

Read-only operation listing table names.

safe

describe_table

Provides detailed schema information for a specified table, including column names and types.

Read-only operation describing table schema.

Safety Assessment

This server is generally safe for read-only exploration of SQLite databases due to built-in query validation and sanitization. However, ensure the `SQLITE_DB_PATH` environment variable is correctly configured and the database contains no sensitive information that could be exposed through schema exploration.

Read-only access to SQLite databases prevents data modification.
Query validation and sanitization mitigate SQL injection risks.
Parameter binding ensures safe query execution.
Row limit enforcement prevents excessive data retrieval.
Progress output suppression ensures clean JSON responses.

Exposure of database schema information could aid reconnaissance.
Improperly configured environment variables could lead to unintended database access.
Reliance on `fastmcp` framework introduces a dependency risk.
Lack of authentication beyond environment variable could be a vulnerability.