v0.1.0
DernièreFirst release of socAdmin — a modern, self-hosted database admin tool for MySQL, PostgreSQL and MongoDB.
Added
- Full CRUD on databases, tables, collections and rows/documents
- SQL query editor with history for MySQL/MariaDB and PostgreSQL
- MongoDB shell with find, aggregate, indexes, GridFS, roles and change streams
- Multi-user authentication with bcrypt, JWT sessions and refresh tokens
- Rate limiting (5 login attempts, 200 req/min global)
- Database credentials encrypted at rest with AES-256-GCM
- CSRF protection, security headers and IP whitelist
- Import/export in SQL, CSV and JSON formats
- Schema visualization with foreign key relationships
- TLS support via
TLS_CERT/TLS_KEYenvironment variables - Auto-provision admin from
ADMIN_EMAIL/ADMIN_PASSWORDenv vars - Docker image (~30 MB) with non-root user and read-only filesystem
- socAdmin Manager desktop app (macOS, Windows, Linux) with one-click start/stop
- Manager can detect and install MySQL, PostgreSQL, MongoDB automatically
- First-launch setup flow with guided database engine installation
- MongoDB FCV auto-repair when upgrading between major versions
- Version display in the Manager UI
- Xcode Command Line Tools detection and error guidance on macOS