{"id":44814,"library":"easy-sqlite-mcp","title":"Easy SQLite MCP","description":"An MCP server for LLMs to interact with SQLite databases, built with Node.js and TypeScript. Current stable version is 1.0.5. Supports two modes: Manual (agent must call sqlite_open/sqlite_close) and Fixed (single database path via SQLITE_PATH environment variable). Provides tools for querying, executing writes, listing tables, and describing schemas. Uses better-sqlite3 under the hood and ships TypeScript definitions. Released as an npm package that can be run directly via npx. Does not support multiple simultaneous databases in Manual mode.","status":"active","version":"1.0.5","language":"javascript","source_language":"en","source_url":"https://github.com/chenkumi/easy-sqlite-mcp","tags":["javascript","mcp","mcp-server","sqlite","database","better-sqlite3","typescript"],"install":[{"cmd":"npm install easy-sqlite-mcp","lang":"bash","label":"npm"},{"cmd":"yarn add easy-sqlite-mcp","lang":"bash","label":"yarn"},{"cmd":"pnpm add easy-sqlite-mcp","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"This package is primarily used as a CLI tool via npx or direct npm execution. Not a library to import in code.","wrong":"Running as a library import (e.g., import { something } from 'easy-sqlite-mcp') is not intended; use MCP client configuration.","symbol":"MCP server (CLI)","correct":"npx easy-sqlite-mcp"},{"note":"Always use npx -y to auto-install and run. Ensure Node >=18.","wrong":"Using 'npm start' or 'node index.js' as the command.","symbol":"MCP server configuration (Claude Desktop)","correct":"Add to Claude Desktop's mcpServers config: command: 'npx', args: ['-y', 'easy-sqlite-mcp']"},{"note":"In Fixed mode, sqlite_open/sqlite_close are not available. Manual mode is default if SQLITE_PATH is missing.","wrong":"Providing relative paths or not setting SQLITE_PATH when expecting fixed mode.","symbol":"MCP server configuration (Fixed mode)","correct":"Set env.SQLITE_PATH to absolute path."}],"quickstart":{"code":"// Quickstart: Run in Manual mode, then use MCP client (e.g., Claude) to interact.\n// 1. Start the MCP server:\n// npx easy-sqlite-mcp\n//\n// 2. From your MCP client, call tools sequentially:\n// - sqlite_open({ path: '/absolute/path/to/your/database.sqlite' })\n// - sqlite_query({ sql: 'SELECT * FROM users LIMIT 5' })\n// - sqlite_close({})\n// Note: Only one database connection at a time. Always close before opening another.","lang":"typescript","description":"Manual mode workflow: start server, open database, execute query, close connection."},"warnings":[{"fix":"Design your workflow to open, use, and close databases sequentially. Or use Fixed mode if you only need one database.","message":"In Manual mode, only one database file can be open at a time. Opening another file closes the previous connection.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Always set SQLITE_PATH as an environment variable when starting the server (e.g., SQLITE_PATH=/data/db.sqlite npx easy-sqlite-mcp).","message":"Fixed mode is only active if SQLITE_PATH environment variable is set at server startup. Otherwise, the server starts in Manual mode and cannot be switched.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Use sqlite_query for SELECT only. For modifications, call sqlite_execute.","message":"The sqlite_query tool is read-only; it will reject INSERT/UPDATE/DELETE statements. Use sqlite_execute for writes.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Upgrade Node.js to version 18 or higher.","message":"Node.js version must be >=18. Older versions are unsupported.","severity":"breaking","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.5':23 'agent':28 'better':56,94 'better-sqlite3':55,93 'built':14 'call':30 'current':19 'databas':13,36,82,92 'definit':64 'describ':52 'direct':74 'easi':1 'environ':41 'execut':47 'fix':34 'hood':60 'interact':10 'javascript':86 'list':49 'llms':8 'manual':27,84 'mcp':3,5,87,89 'mcp-server':88 'mode':26,85 'multipl':80 'must':29 'node.js':16 'npm':68 'npx':76 'open/sqlite_close':32 'packag':69 'path':37,40 'provid':43 'queri':46 'releas':65 'run':73 'schema':53 'server':6,90 'ship':62 'simultan':81 'singl':35 'sqlite':2,12,31,39,91 'sqlite3':57,95 'stabl':20 'support':24,79 'tabl':50 'tool':44 'two':25 'typescript':18,63,96 'use':54 'variabl':42 'version':21 'via':38,75 'write':48","created_at":"2026-06-07T12:51:57.578062+00:00","updated_at":"2026-06-07T12:51:57.578062+00:00","problems":[{"fix":"Use npx easy-sqlite-mcp (with -y flag to auto-install) or install globally with npm i -g easy-sqlite-mcp.","cause":"Running without npx -y or without installing the package globally.","error":"Error: Cannot find module 'easy-sqlite-mcp'"},{"fix":"Set SQLITE_PATH environment variable or understand that server starts in Manual mode. To force Fixed mode: SQLITE_PATH=/path/to/db.sqlite npx easy-sqlite-mcp","cause":"Assuming Fixed mode without setting the environment variable.","error":"Error: SQLITE_PATH is not set, but mode is Fixed"},{"fix":"Remove sqlite_open calls; use Fixed mode tools starting with sqlite_status. Or switch to Manual mode by omitting SQLITE_PATH.","cause":"Calling sqlite_open in Fixed mode (tool not available).","error":"TypeError: sqlite_open is not a function"},{"fix":"Ensure sqlite_open is called before sqlite_query/sqlite_execute. Monitor connection status via sqlite_status.","cause":"Trying to query after calling sqlite_close, or server restarted in manual mode.","error":"Error: Connection already closed"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/chenkumi/easy-sqlite-mcp#readme","github":"https://github.com/chenkumi/easy-sqlite-mcp","docs":null,"changelog":null,"pypi":null,"npm":"easy-sqlite-mcp","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-07","next_check":"2026-09-05","install_tag":null}}