Log inSubmit server
MCP Sqlite logo

MCP Sqlite

by jparkerweb

Connects an AI agent to a SQLite file for schema inspection, SQL queries, and CRUD operations.

InstallRepositoryWebsite
Full README Compare alternatives Embed widget Claim this listing

Install MCP Sqlite

Pick your client, then add it in one click or paste the config.

STDIONode.js
~/Library/Application Support/Claude/claude_desktop_config.json
claude_desktop_config.json
{
  "mcpServers": {
    "jparkerweb-mcp-sqlite": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite"
      ]
    }
  }
}

Settings → Developer → Edit Config, merge this into mcpServers, then fully quit and reopen Claude Desktop.

Automated check passed— started and listed 8 tools correctly (23d ago).

Overview

jparkerweb/mcp-sqlite MCP server connects an MCP-compatible client to a SQLite database file supplied as a command-line argument. It provides tools for database information, table listing, schema inspection, raw SQL execution, and record-level create, read, update, and delete operations. Use it when an agent needs to inspect or modify a local SQLite database through structured MCP tool calls. The server runs through stdio and can be configured in clients such as Cursor and VS Code.

Use cases

  • Inspect SQLite tables and schemas
  • Run parameterized SQL queries
  • Insert records into SQLite tables
  • Read filtered records with pagination
  • Update or delete matching records

Key features

  • SQLite database information and introspection
  • Raw SQL queries with optional values
  • Table and schema discovery
  • Create, read, update, and delete operations
  • Stdio configuration through npx

Tools8

What MCP Sqlite lets your agent do. Expand a tool for its parameters.

Verified live~605 tokens of context

Security & health

What it can reach and how reliably it runs — from our own checks, not the maintainer’s claims.

ActiveLast checked Today

Recent health check succeeded.

19/19 checks healthy over the last 76d

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 7d ago via OSV.dev · mcp-sqlite (npm)

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars131Stargazers on the source repository.
npm downloads3.4kPackage downloads in the last 30 days.
Last commit6mo agoMost recent push to the default branch.
Availability100%Our rolling endpoint + install checks that succeeded.
Install checkPassedOur sandbox started it and listed its tools.
Tools exposed8Callable tools this server registers over MCP.
Directory activity5 viewsConfig copies, upvotes, and views on AllMCPs.

How MCP Sqlite works

What jparkerweb/mcp-sqlite MCP server does

The jparkerweb/mcp-sqlite MCP server exposes a SQLite database to an MCP-compatible AI client. It accepts the path to a database file when the server starts, then provides tools for examining the database, running SQL, and changing table records. The repository identifies the project as built with the Model Context Protocol SDK and the sqlite3 package.

This fits the 🗄️ Databases category because its scope is limited to SQLite database access. It does not describe a hosted database connection, an ORM, migrations, authentication, or support for database engines other than SQLite.

How it works

The client starts the server as a stdio process and passes the database path as an argument. Once connected, an agent can call inspection tools to determine whether the database exists, view its size and table count, list user tables, or retrieve the columns and schema details for a named table.

For data access, the server offers both structured record operations and a general SQL entry point. Record operations accept table names and key-value objects for data or conditions. The read_records tool also accepts an optional limit and offset. The query tool accepts SQL text and an optional array of values, allowing parameterized statements such as a lookup using a positional placeholder.

Setup and configuration

Install and configure the server through an MCP client's server settings. The database path is required as the final argument.

A Cursor configuration uses a server entry with command set to npx and arguments equivalent to -y, mcp-sqlite, and the path to the SQLite file. The VS Code example uses the same command and arguments, with the server type set to stdio. Replace the placeholder path with the database file the agent should access.

Tools and capabilities

The jparkerweb/mcp-sqlite MCP server includes these tools:

  • db_info: Reports the database path, whether it exists, its size, and its table count.
  • list_tables: Lists user tables while excluding system tables.
  • get_table_schema: Returns column and schema information for a specified table.
  • query: Executes raw SQL with optional parameter values.
  • create_record: Inserts a record using key-value data.
  • read_records: Retrieves records with optional conditions, limit, and offset.
  • update_records: Changes values in rows matching supplied conditions.
  • delete_records: Removes rows matching supplied conditions.

Together, these tools cover database inspection, custom SQL, and CRUD workflows. The jparkerweb/mcp-sqlite MCP server can therefore support agents that need to understand an existing SQLite schema before reading or modifying its data.

Limitations and notes

The documented database target is SQLite, and the examples show local stdio configuration rather than a network service. Because the server exposes raw SQL and write operations, configure the client with an appropriate database file and review agent access before allowing changes to important data.

Read the full README View source on GitHub

Reviews

No reviews yet — be the first to share how it worked for you.

Frequently Asked Questions about MCP Sqlite

jparkerweb/mcp-sqlite is an MCP server that connects an MCP-compatible AI client to a SQLite database file. Its main tools provide database information, table and schema inspection, raw SQL queries, and create, read, update, and delete operations on table records.

Run it through an MCP client with `npx -y mcp-sqlite <path-to-your-sqlite-database.db>`. Add that command and its arguments to the client's MCP server settings, then replace the placeholder with the required SQLite database path.

Yes, jparkerweb/mcp-sqlite includes a Cursor configuration example. Define an MCP server whose command is `npx` and whose arguments are `-y`, `mcp-sqlite`, and the path to the SQLite database file.

Yes, it provides `update_records` and `delete_records` tools. Both use a table name and conditions expressed as key-value pairs; updates also receive the replacement data.

Yes, the `query` tool executes custom SQL against the connected SQLite database. It accepts the SQL string and an optional array of parameter values for statements using placeholders.

Related MCP servers

All in Databases All alternatives
Add a badge to your READMEShow it’s listed — live SVG, Markdown or HTML.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:
Live Dynamic SVG PreviewMCP Sqlite AllMCPs Directory Badge
Markdown (GitHub README)
[![AllMCPs](https://allmcps.com/api/badge/jparkerweb-mcp-sqlite?style=directory)](https://allmcps.com/mcp/jparkerweb-mcp-sqlite)
HTML Embed
<a href="https://allmcps.com/mcp/jparkerweb-mcp-sqlite"><img src="https://allmcps.com/api/badge/jparkerweb-mcp-sqlite?style=directory" alt="MCP Sqlite on AllMCPs" /></a>