Panopticum

A tool for developers and QA — web interface for viewing and managing database connections. Designed for deployment in Kubernetes or Docker.

Stack:

• Backend: Micronaut 4.x
• Views: Thymeleaf + HTMX
• API: REST API for all operations; Swagger/OpenAPI 3.0
• Auth: HTTP Basic (login/password from environment)
• Storage: H2 (Flyway migrations)
• i18n: English and Russian

Supported databases:

• PostgreSQL / CockroachDB / YugabyteDB — Browse databases, schemas, tables; run SQL; edit rows
• MySQL / MariaDB — Browse databases and tables; run SQL; edit rows (if table has PK or unique index)
• MS SQL Server — Browse databases, schemas, tables; run SQL; edit rows (if table has PK or unique index)
• Oracle Database — Browse schemas and tables; run SQL; edit rows by ROWID
• MongoDB — Browse databases and collections; run queries
• Redis / Dragonfly / Valkey / KeyDB — Browse databases and keys; view key types and values
• ClickHouse — Browse databases and tables; run SQL
• Cassandra / ScyllaDB — Browse keyspaces and tables; run CQL; edit rows (when table has primary key)
• RabbitMQ — Browse queues; peek messages (read-only, no edit/delete)
• Kafka — Browse topics and partitions; peek records (read-only)
• Elasticsearch / OpenSearch — Browse indices; search (Query DSL); view and edit documents by _id

Key Features:

• HTTP Basic Auth (credentials from env)
• Light and dark theme (toggle in header and on login page)
• Sidebar with saved connections and quick access to Settings; tree view for connections using "/" in connection names to create folders (e.g., "Dev/PG", "Prod/Mongo")
• Add, test, and remove connections per database type
• Browse metadata (schemas, tables, collections, keys) with pagination
• Execute SQL (PostgreSQL, MySQL, MS SQL Server, Oracle, ClickHouse, Cassandra CQL) and queries (MongoDB)
• Edit and save rows in detail view
• REST API for all database operations
• Swagger UI at /swagger-ui for interactive API documentation
• HTMX for partial updates without full page reloads
• JSON syntax highlighting
• Offline / closed-circuit: all vendor assets bundled locally — no CDN required
• Localization: EN and RU
• Data Diff: compare records side-by-side across environments or different DB types
• MCP (Model Context Protocol): JSON-RPC endpoint at /mcp for AI agents — list data sources, browse catalogs/schemas/tables, run queries, and compare records across databases

Running:

./gradlew run

Application: http://localhost:8080

Docker:

docker pull ghcr.io/thesharque/panopticum:latest docker run -d --name panopticum -p 8080:8080 -v panopticum-data:/data -e PANOPTICUM_USER=admin -e PANOPTICUM_PASSWORD=changeme ghcr.io/thesharque/panopticum:latest