Metadata-Version: 2.4
Name: mcp-sqlite3
Version: 0.1.2
Summary: MCP server exposing sqlite3 library functionality
Project-URL: Homepage, https://github.com/daedalus/mcp-sqlite3
Project-URL: Repository, https://github.com/daedalus/mcp-sqlite3
Project-URL: Issues, https://github.com/daedalus/mcp-sqlite3/issues
Author-email: Dario Clavijo <clavijodario@gmail.com>
License: MIT
License-File: LICENSE
Requires-Python: >=3.11
Requires-Dist: fastmcp>=0.1.0
Provides-Extra: all
Requires-Dist: hatch; extra == 'all'
Requires-Dist: hypothesis; extra == 'all'
Requires-Dist: mypy; extra == 'all'
Requires-Dist: pip-api; extra == 'all'
Requires-Dist: pytest; extra == 'all'
Requires-Dist: pytest-asyncio; extra == 'all'
Requires-Dist: pytest-cov; extra == 'all'
Requires-Dist: pytest-mock; extra == 'all'
Requires-Dist: ruff; extra == 'all'
Provides-Extra: dev
Requires-Dist: hatch; extra == 'dev'
Requires-Dist: mypy; extra == 'dev'
Requires-Dist: pip-api; extra == 'dev'
Requires-Dist: ruff; extra == 'dev'
Provides-Extra: lint
Requires-Dist: mypy; extra == 'lint'
Requires-Dist: ruff; extra == 'lint'
Provides-Extra: test
Requires-Dist: hypothesis; extra == 'test'
Requires-Dist: pytest; extra == 'test'
Requires-Dist: pytest-asyncio; extra == 'test'
Requires-Dist: pytest-cov; extra == 'test'
Requires-Dist: pytest-mock; extra == 'test'
Description-Content-Type: text/markdown

# mcp-sqlite3

> MCP server exposing sqlite3 library functionality

[![PyPI](https://img.shields.io/pypi/v/mcp-sqlite3.svg)](https://pypi.org/project/mcp-sqlite3/)
[![Python](https://img.shields.io/pypi/pyversions/mcp-sqlite3.svg)](https://pypi.org/project/mcp-sqlite3/)
[![Ruff](https://img.shields.io/endpoint?url=https://raw.githubusercontent.com/astral-sh/ruff/main/assets/badge/v2.json)](https://github.com/astral-sh/ruff)

## Install

```bash
pip install mcp-sqlite3
```

## Usage

```python
from mcp_sqlite3 import mcp_server

mcp_server.run()
```

## CLI

```bash
mcp-sqlite3 --help
```

## API

Exposes complete sqlite3 functionality as MCP tools.

### Connection Tools
- `connect_database` - Open a database connection
- `close_connection` - Close a database connection
- `commit` / `rollback` - Transaction control

### SQL Execution Tools
- `execute_query` - Execute a query and return results
- `execute_many` - Execute with multiple parameter sets
- `execute_script` - Execute a SQL script

### Schema Tools
- `list_tables` - List all tables
- `get_table_info` - Get table schema
- `create_table` / `drop_table` - DDL operations

### CRUD Tools
- `insert_row` / `update_rows` / `delete_rows` / `select_rows`

## Development

```bash
git clone https://github.com/daedalus/mcp-sqlite3.git
cd mcp-sqlite3
pip install -e ".[test]"

# run tests
pytest

# format
ruff format src/ tests/

# lint
ruff check src/ tests/

# type check
mypy src/
```

## MCP Server

mcp-name: io.github.dclavijo/mcp-sqlite3
