MCP Server Sqlite

What ofershap/mcp-server-sqlite MCP server does

The ofershap/mcp-server-sqlite MCP server connects an MCP client to local SQLite database files. It is intended for inspecting database structure, running read-oriented SQL, and understanding how SQLite plans to execute a query. The server accepts database paths through tool requests and returns query results in a table format.

The project is implemented for a TypeScript and Node.js workflow and can be launched with the published mcp-sqlite-server package. It does not require credentials because it works with files available on the local machine.

How it works

The server provides separate operations for database discovery, schema inspection, table details, SQL execution, and query-plan analysis. list_databases searches a directory for files ending in .db, .sqlite, or .sqlite3. schema reports every table along with its columns, types, and row counts. table_info narrows that view to one table and includes columns, constraints, and the row count.

The query operation supports SELECT, PRAGMA, EXPLAIN, and WITH statements in its default mode. Results are returned as a table for the calling assistant to interpret. The explain operation runs SQLite's EXPLAIN QUERY PLAN, which can help investigate how a query is likely to access tables and indexes.

Setup and configuration

Install and run the ofershap/mcp-server-sqlite MCP server with:

npx -y mcp-sqlite-server

An MCP client can configure the server as a local stdio process using npx and the mcp-sqlite-server package. The README gives configuration examples for Cursor and Claude Desktop, and also states that the server can be configured in VS Code. Other MCP clients may use it if they support local stdio servers.

No API key, token, or other authentication setting is documented. The server reads local database files, so the client environment must be able to access the paths supplied to the tools.

Tools and capabilities

• query: Runs supported SQL and returns tabular results.
• schema: Lists all tables with column definitions, types, and row counts.
• table_info: Shows one table's columns, constraints, and row count.
• explain: Runs EXPLAIN QUERY PLAN for query analysis.
• list_databases: Finds SQLite database files in a selected directory.

Limitations and notes

Read-only behavior is enabled by default. In that mode, query accepts only SELECT, PRAGMA, EXPLAIN, and WITH statements. Passing readonly=false in the tool arguments enables write operations such as INSERT, UPDATE, and DELETE, so that setting should be used deliberately.

The documented interface is focused on SQLite files and does not describe connections to hosted database services. The listed tools also do not define a separate export operation; query results are returned to the MCP client as tables. The package is distributed under the MIT license.