socAdmin

Changelog

What changed in each version of socAdmin.

v0.2.0

Latest

Security hardening, performance improvements and accessibility fixes across the entire application.

Added

  • Graceful shutdown — the server now handles SIGTERM/SIGINT and drains in-flight requests before exiting
  • Request body size limit (1 MB default) to prevent out-of-memory attacks on JSON endpoints
  • Query timeout (30s) on the MySQL connector, aligned with PostgreSQL
  • Email format validation on register and user creation
  • Dedicated /-/health endpoint for Docker HEALTHCHECK (no auth, no prefix)
  • Backend health check banner with countdown, retry button and reconnection feedback
  • Responsive mobile layout for all pages
  • Global keyboard shortcuts for dashboard navigation
  • ConnMaxLifetime and ConnMaxIdleTime on MySQL and PostgreSQL connection pools
  • aria-label on all icon-only buttons for screen readers

Changed

  • All 24 dashboard views now lazy-load with React.lazy() — smaller initial bundle
  • SearchGlobal capped to 50 tables and 200 total results to prevent runaway scans
  • CI now runs frontend tests (vitest) and coverage threshold raised to 15%
  • Schema view enhanced with hover highlighting, minimap and cardinality labels

Fixed

  • Docker HEALTHCHECK was targeting / instead of a real health endpoint
  • Rate limiter goroutine leak — cleanup goroutine can now be stopped
  • TypeScript useRef and ESLint set-state-in-effect errors in health check hook

v0.1.0

First release of socAdmin — a modern, self-hosted database admin tool for MySQL, PostgreSQL and MongoDB.

Show the 14 changes Hide the changes

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_KEY environment variables
  • Auto-provision admin from ADMIN_EMAIL / ADMIN_PASSWORD env 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