# v1.0.0 - Production Release

**Released: February 4, 2026**

🎉 First stable release of db-mcp, the comprehensive SQLite MCP Server.

## Highlights

- **122 Specialized Tools** across 7 groups: Core, JSON, Text, Stats, Vector, Geo, Admin
- **OAuth 2.1 Authentication** - RFC 9728/8414 compliant with Keycloak integration
- **Dual Transport** - stdio (default) and HTTP/SSE with streamable sessions
- **Smart Tool Filtering** - Presets (starter, analytics, search) for AI IDE limits
- **Native + WASM** - better-sqlite3 for full power, sql.js for portability
- **Docker Multi-Platform** - linux/amd64 + linux/arm64 (Apple Silicon)

## Features

### Tool Groups

| Group  | Native | WASM | Description                            |
| ------ | ------ | ---- | -------------------------------------- |
| Core   | 8      | 8    | CRUD, schema, indexes, views           |
| JSON   | 23     | 23   | JSON/JSONB, schema analysis            |
| Text   | 17     | 13   | FTS5, fuzzy, phonetic, regex           |
| Stats  | 19     | 13   | Statistical analysis, window functions |
| Vector | 11     | 11   | Embeddings, similarity search          |
| Geo    | 11     | 4    | Geospatial + SpatiaLite (Native)       |
| Admin  | 33     | 26   | Backup, restore, virtual tables        |

### Security

- OAuth 2.1 with PKCE and dynamic client registration
- Input validation and SQL injection protection
- Non-root Docker containers
- Docker Scout security scanning in CI/CD

### Infrastructure

- GitHub Actions CI/CD with Node.js 22/24/25 matrix
- Automated Docker Hub publishing on push to main
- npm publishing on GitHub releases
- MCP Registry integration

## Installation

### Docker (Recommended)

```bash
docker pull writenotenow/db-mcp:v1.0.0
```

### npm

```bash
npm install -g db-mcp
```

## Documentation

- **[GitHub Wiki](https://github.com/neverinfamous/db-mcp/wiki)** - Complete documentation
- **[Docker Hub](https://hub.docker.com/r/writenotenow/db-mcp)** - Container images
- **[Changelog](https://github.com/neverinfamous/db-mcp/blob/main/CHANGELOG.md)** - Full history

## Contributors

Built by [@neverinfamous](https://github.com/neverinfamous)
