# 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)
