# SQLite MCP server

> Allows an AI client to perform CRUD operations, explore schemas, and execute custom SQL queries on a SQLite database.

- Repository: https://github.com/jparkerweb/mcp-sqlite
- Page: https://hostedmcp.org/servers/jparkerweb/mcp-sqlite
- Transport: stdio
- Stars: 130
- License: MIT

## Install

### Claude Code

```sh
claude mcp add mcp-sqlite -- npx -y mcp-sqlite
```

### Cursor (`~/.cursor/mcp.json`)

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

### VS Code (`.vscode/mcp.json`)

```json
{
  "servers": {
    "mcp-sqlite": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-sqlite"
      ]
    }
  }
}
```

### VS Code CLI

```sh
code --add-mcp '{"name":"mcp-sqlite","type":"stdio","command":"npx","args":["-y","mcp-sqlite"]}'
```

### Claude Desktop (`claude_desktop_config.json`)

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

### Codex

```sh
codex mcp add mcp-sqlite -- npx -y mcp-sqlite
```

### Codex config.toml (`~/.codex/config.toml`)

```toml
[mcp_servers.mcp-sqlite]
command = "npx"
args = ["-y", "mcp-sqlite"]
```

### Gemini CLI

```sh
gemini mcp add -s user mcp-sqlite npx -- -y mcp-sqlite
```

### Gemini settings.json (`~/.gemini/settings.json`)

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

## FAQ

### Can I run my own SQL queries?

Yes, you can use the query tool to execute custom SQL queries against the connected database, optionally using parameter values.
