{"library":"mcp-sqlite","title":"MCP SQLite Server","description":"An MCP (Model Context Protocol) server providing SQLite database interaction for AI agents. Version 1.0.9 (April 2026) includes critical SQL injection vulnerability fixes (CWE-89). The server exposes CRUD operations (create_record, read_records, update_records, delete_records), database introspection (list_tables, get_table_schema, db_info), and custom SQL execution. It is designed to be run as a stdio-based MCP tool in IDEs like Cursor, VS Code, and Windsurf. Compared to raw better-sqlite3 usage, it abstracts SQL via MCP tool calls and validates identifiers against sqlite_master. Requires Node >= 14.","language":"javascript","status":"active","last_verified":"Sat Apr 25","install":{"commands":["npm install mcp-sqlite"],"cli":{"name":"mcp-sqlite","version":null}},"imports":["npx -y mcp-sqlite <path-to-db>","{\"method\":\"tools/call\",\"params\":{\"name\":\"create_record\",\"arguments\":{\"table\":\"users\",\"data\":{\"name\":\"John\"}}}}","{\"mcpServers\":{\"MCP SQLite Server\":{\"command\":\"npx\",\"args\":[\"-y\",\"mcp-sqlite\",\"path/to/db.db\"]}}}","{\"servers\":{\"MCP SQLite Server\":{\"type\":\"stdio\",\"command\":\"npx\",\"args\":[\"-y\",\"mcp-sqlite\",\"path/to/db.db\"]}}}"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"// Create an SQLite database and run a Cursor MCP server example\n// First, create a test database:\n$ touch test.db\n// Add Cursor MCP configuration to ~/.cursor/mcp.json:\n{\n  \"mcpServers\": {\n    \"MCP SQLite Server\": {\n      \"command\": \"npx\",\n      \"args\": [\"-y\", \"mcp-sqlite\", \"/absolute/path/to/test.db\"]\n    }\n  }\n}\n// Restart Cursor and call the tool via MCP:\n// \"list_tables\" returns empty if no tables\n// Example create_record call:\n{\n  \"method\": \"tools/call\",\n  \"params\": {\n    \"name\": \"create_record\",\n    \"arguments\": {\n      \"table\": \"users\",\n      \"data\": {\n        \"name\": \"Alice\",\n        \"email\": \"alice@example.com\"\n      }\n    }\n  }\n}\n// Response: {\"content\":[{\"type\":\"text\",\"text\":\"Record created: id=1\"}]}\n// Note: database path must be absolute or relative to CWD","lang":"typescript","description":"Demonstrates setting up mcp-sqlite with Cursor, creating a table, inserting a record, and reading it back via MCP tools.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}