---
title: "SQLite MCP Server Setup Guide and Schema"
slug: "sqlite"
category: "databases"
package: "mcp-server-sqlite"
transport: "stdio"
canonical: "https://mcp-codex.com/servers/sqlite"
source: "MCP Codex (https://mcp-codex.com)"
dateModified: "2026-09-28"
---

# SQLite MCP Server

> Query and inspect local SQLite databases, explore schemas and indexes.

## Overview
Connect your AI agent to SQLite databases for schema inspection, table querying, and data analysis. Uses the Python-based mcp-server-sqlite package via uvx. Ideal for local development, prototyping, and embedded database workflows.

## Quick Install
```bash
uvx mcp-server-sqlite --db-path ./data.db
```

## Client Configurations

### Claude Desktop (`claude_desktop_config.json`)
```json
{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "./data.db"
      ]
    }
  }
}
```

### Cursor (`mcp.json`)
```json
{
  "mcpServers": {
    "sqlite": {
      "command": "uvx",
      "args": [
        "mcp-server-sqlite",
        "--db-path",
        "./data.db"
      ]
    }
  }
}
```

### OpenAI Codex CLI (`~/.codex/config.toml`)
```toml
[mcp_servers.sqlite]
command = "uvx"
args = ["mcp-server-sqlite", "--db-path", "./data.db"]
```

## Available Tools (6)

- `read_query`
- `write_query`
- `create_table`
- `list_tables`
- `describe_table`
- `append_insight`

## Documentation & Links
- Canonical Web Page: https://mcp-codex.com/servers/sqlite
- Weekly Protocol Changelog: https://mcp-codex.com#newsletter
- GitHub Repository: https://github.com/modelcontextprotocol/servers/tree/main/src/sqlite
- Setup Tutorial Guide: https://mcp-codex.com/articles/sqlite-mcp-server-guide