easy-sqlite-mcp

Return the SQLite MCP manual. Use this first when you are unsure how to use sqlite_open, sqlite_query, sqlite_execute, or when an operation fails and you need the safe usage rules, placeholder rules, or database lifecycle guidance.

Open an SQLite database file at the specified path. Args: - file_path (string): Absolute or relative path to the .db / .sqlite file. Returns: { "success": boolean, "message": string } Examples: - "Open the users database" -> file_path="/data/users.db" Error Handling: - Returns success=false with message if the file cannot be opened.

Close the currently open SQLite database connection. Returns: { "success": boolean, "message": string } Error Handling: - Returns success=false if no database is currently open.

Get the current status of the SQLite database connection. Returns: { "isOpen": boolean, "filePath": string | null, "memoryUsage": number | null, "tables": number | null }

Execute a read-only SQL query (SELECT) on the currently open database. Args: - sql (string): The SQL SELECT statement to execute. - params (object, optional): Named parameters for the query. Use placeholder names without the SQL prefix in the params object, e.g. SQL ":id" uses params { "id": 1 }. Returns: { "columns": string[], "rows": unknown[][], "rowCount": number } Error Handling: - Throws if no database is open. Use sqlite_open first. - Returns SQL error message if the query is invalid.

Execute a write SQL statement (INSERT, UPDATE, DELETE, CREATE, DROP, ALTER) on the currently open database. Args: - sql (string): The SQL statement to execute. - params (object, optional): Named parameters for the statement. Use placeholder names without the SQL prefix in the params object, e.g. SQL ":id" uses params { "id": 1 }. Returns: { "changes": number, "lastInsertRowid": number } Error Handling: - Throws if no database is open. Use sqlite_open first. - Returns SQL error message if the statement is invalid.

List all user tables in the currently open SQLite database. Returns: { "tables": string[] } Error Handling: - Throws if no database is open. Use sqlite_open first.

Describe the schema of a specific table in the currently open SQLite database. Args: - table_name (string): Name of the table to describe. Returns: { "name": string, "columns": [ { "cid": number, "name": string, "type": string, "notnull": boolean, "defaultValue": unknown, "pk": boolean } ], "rowCount": number } Error Handling: - Throws if no database is open. Use sqlite_open first. - Returns error if the table does not exist.