Loading...
{
"mcpServers": {
"my_sqlite_db": {
"command": "uvx",
"args": ["--from", "mcp-alchemy==2025.8.15.91819",
"--refresh-package", "mcp-alchemy", "mcp-alchemy"],
"env": {
"DB_URL": "sqlite:////absolute/path/to/database.db"
}
}
}
}all_table_namesRetrieves all table names in the connected database.
Read-only operation; no data modification.
filter_table_namesFinds table names matching a specified substring.
Read-only operation; no data modification.
schema_definitionsGets detailed schema information for specified tables.
Read-only operation; no data modification.
execute_queryExecutes an arbitrary SQL query against the database.
Can modify, delete, or expose sensitive data based on the query.
MCP Alchemy's safety depends on the user's SQL query practices. Read-only operations are relatively safe. However, executing arbitrary SQL queries can be risky if not properly sanitized, potentially leading to data breaches or modifications. Limit access and monitor query execution.