Back to MCP Directory
Connections & Capabilities
Connects To
GitHubSQLite
Capabilities
read
Quickstart
Install
pip install -rConfig
{
"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_queryExecutes a SELECT query on the database with safety validations and returns results as dictionaries.
Read-only operation with query validation.
safe
list_tablesLists all available tables in the database.
Read-only operation listing table names.
safe
describe_tableProvides 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.