# Mcp Server Sqlite

> MCP server for SQLite — query databases, inspect schemas, explain queries

- **Type:** MCP server
- **Install:** `agentstack add mcp-ofershap-mcp-server-sqlite`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [ofershap](https://agentstack.voostack.com/s/ofershap)
- **Installs:** 0
- **Category:** [Databases](https://agentstack.voostack.com/c/databases)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [ofershap](https://github.com/ofershap)
- **Source:** https://github.com/ofershap/mcp-server-sqlite

## Install

```sh
agentstack add mcp-ofershap-mcp-server-sqlite
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# mcp-server-sqlite

[](https://www.npmjs.com/package/mcp-sqlite-server)
[](https://www.npmjs.com/package/mcp-sqlite-server)
[](https://github.com/ofershap/mcp-server-sqlite/actions/workflows/ci.yml)
[](https://www.typescriptlang.org/)
[](https://opensource.org/licenses/MIT)

Query SQLite databases, inspect schemas, and explain queries from your AI assistant. Read-only by default for safety.

```bash
npx mcp-sqlite-server
```

> Works with Claude Desktop, Cursor, VS Code Copilot, and any MCP client. Reads local `.db` files, no auth needed.

Demo built with remotion-readme-kit

## Why

SQLite is everywhere. It's the default database for mobile apps, Electron apps, local-first tools, and increasingly for server-side projects too (Turso, Cloudflare D1, Bun's built-in SQLite). The official MCP reference includes a basic SQLite server, but it's Python-only. If you're working in a TypeScript/Node.js environment and want to ask your assistant "what tables are in this database?" or "run this query and show me the results," this server handles that. It opens the database read-only by default so you can explore safely, and you can opt into write mode when you need it.

## Tools

| Tool             | What it does                                                             |
| ---------------- | ------------------------------------------------------------------------ |
| `query`          | Execute SQL (SELECT, PRAGMA, EXPLAIN, WITH). Returns results as a table. |
| `schema`         | Get full schema: all tables with columns, types, and row counts.         |
| `table_info`     | Detailed info for a single table: columns, constraints, row count.       |
| `explain`        | Run EXPLAIN QUERY PLAN to optimize queries.                              |
| `list_databases` | List .db, .sqlite, .sqlite3 files in a directory.                        |

## Quick Start

### Cursor

Add to `.cursor/mcp.json`:

```json
{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["mcp-sqlite-server"]
    }
  }
}
```

### Claude Desktop

Add to `claude_desktop_config.json` (macOS: `~/Library/Application Support/Claude/claude_desktop_config.json`):

```json
{
  "mcpServers": {
    "sqlite": {
      "command": "npx",
      "args": ["mcp-sqlite-server"]
    }
  }
}
```

### VS Code

Configure the MCP server in your VS Code settings to run `npx mcp-sqlite-server`.

## Example prompts

- "Show me the schema of my database at ./data.db"
- "Query the users table: SELECT \* FROM users LIMIT 10"
- "Explain the query plan for this complex join"
- "What tables are in this database?"
- "Find all .db files in the current directory"

## Safety

Read-only by default. The `query` tool accepts only SELECT, PRAGMA, EXPLAIN, and WITH in readonly mode. Set `readonly=false` in the tool args to enable INSERT, UPDATE, DELETE, etc.

## Development

```bash
npm install
npm run typecheck
npm run build
npm test
npm run format
npm run lint
```

## See also

More MCP servers and developer tools on my [portfolio](https://gitshow.dev/ofershap).

## Author

[](https://gitshow.dev/ofershap)

[](https://linkedin.com/in/ofershap)
[](https://github.com/ofershap)

---

README built with [README Builder](https://ofershap.github.io/readme-builder/)

## License

MIT © 2026 Ofer Shapira

## Source & license

This open-source MCP server is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [ofershap](https://github.com/ofershap)
- **Source:** [ofershap/mcp-server-sqlite](https://github.com/ofershap/mcp-server-sqlite)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/mcp-ofershap-mcp-server-sqlite
- Seller: https://agentstack.voostack.com/s/ofershap
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.