This MCP server provides comprehensive SQLite database operations for AI assistants, enabling safe and efficient interactions with local SQLite databases. It includes built-in security features and advanced transaction support.
From the registry: MCP server for local SQLite database operations
Please install the `mcp-sqlite-tools` MCP server into my current AI client (that's you).
Canonical MCP server config (stdio transport):
- command: `npx`
- args: ["-y","mcp-sqlite-tools"]
- optional environment variables:
- `SQLITE_DEFAULT_PATH`: Default directory for database files (example: `.`)
- `SQLITE_ALLOW_ABSOLUTE_PATHS`: Allow absolute paths in database operations (example: `true`)
- `SQLITE_BACKUP_PATH`: Default directory for backups (example: `./backups`)
- `SQLITE_MAX_QUERY_TIME`: Maximum query execution time (ms) (example: `30000`)
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.SQLITE_DEFAULT_PATHrequiredDefault directory for SQLite databases.SQLITE_ALLOW_ABSOLUTE_PATHSrequiredAllow absolute paths for database files.SQLITE_MAX_QUERY_TIMErequiredMaximum query execution time in milliseconds.SQLITE_BACKUP_PATHrequiredDefault directory for database backups.Minimal, token-efficient Database MCP Server for PostgreSQL, MySQL, SQL Server, SQLite, MariaDB