All notable changes to DBA Coworker are documented here.
- Dark navy sidebar (#1a1a2e) with orange accent (#e8651a) matching amvana.com
- Orange gear logo with "YS" text replacing blue gradient "PG" badge
- Montserrat font (body) + Source Code Pro (code) replacing DM Sans + IBM Plex
- Orange tab underlines, active states, and accent colors throughout
- Server tree redesigned for dark background with green/red status dots
- Toggle button (☀️/🌙) in top bar
- Affects main content, top bar, tab bar, and cards via CSS variables
- Sidebar remains dark in both modes
- Auto-detects PRIMARY vs STANDBY via
pg_is_in_recovery() - Primary view: WAL info (level, LSN, file count, size), streaming standbys with lag/delay, replication slots with retained WAL, publications with table counts
- Standby view: WAL receiver connection to primary, receive/replay LSN, replay delay in seconds, replay lag in bytes, subscriptions with activity stats
- Health grade (A+ to F) with scored checks: slot health, streaming lag, WAL receiver status, replay delay, publication coverage, subscription errors
- Subscription error detection from
pg_stat_subscription_stats - Replication conflict tracking from
pg_stat_database_conflicts
- SVG arc gauges: Active Sessions (AAS vs vCPU), Connection Pool (used vs max), Cache Hit Ratio with color thresholds
- Wait Event donut chart: CPU/IO/Lock/LWLock/BufferPin/IdleTxn breakdown with percentages
- Gauges use green/yellow/red thresholds for instant health assessment
- Sortable columns: click header to toggle ▼ desc / ▲ asc
- Heatmap cells: Avg ms (green=fast, red=slow), Cache Hit% (inverse)
- Inline bar charts: Total ms column shows proportional background bar
- Click-to-expand: click any row for full SQL text + all metrics
- EXPLAIN ANALYZE button: run EXPLAIN on any query directly
- Pagination: 50 rows per page with page navigation
- Search/filter: real-time SQL text filtering
- Log parser engine (deadlocks, fatals, errors, slow queries, locks, restarts, checkpoints, autovacuum)
- Server state snapshot collection
- Claude AI-powered Root Cause Analysis
- 3 views: Log Input, Parsed Events, RCA Report
- Full CDC pipeline monitoring: MSSQL → Kafka/Debezium → PostgreSQL → Logical Replication
- Publisher view: WAL info, replication slots, streaming connections, publications
- Subscriber view: subscriptions, activity stats
- Row count comparison (publisher vs subscriber tables)
- Kafka Connect integration (connector status, task health)
- Pipeline health check with A+ to F grading (11 checks)
- Average Active Sessions (AAS) stacked area chart
- Wait event classification (CPU, IO, Lock, LWLock, BufferPin, IdleInTransaction)
- Multi-dimensional slicing: by Wait Events, Top SQL, Users, Hosts, Databases
- Auto-sampling with 10s intervals
- Top SQL integration with pg_stat_statements
- Comprehensive health scoring system
- Fleet-wide health dashboard
- Dead tuple tracking with vacuum recommendations
- pg_profile snapshot management
- 12-point tuning score graded A-F (rule-based, no AI needed)
- Full workload profile: OLTP/OLAP classification, read/write %, all params
- AI-powered recommendations with ready-to-run ALTER SYSTEM commands
- SQL autocomplete (tables, columns, functions, keywords)
- SQL formatter (uppercase keywords, indentation, clause separation)
- Visual query builder (click tables → columns → FK joins → generate SQL)
- 12 SQL snippet templates
- EXPLAIN ANALYZE visual tree with color-coded plan nodes
- Upload Git project SQL files and compare against live database
- Side-by-side diff viewer (project vs server)
- 8 object types: tables, functions, views, materialized views, triggers, sequences, extensions, types
- Export live schema as project files
- 11 backup types: single DB, schema-only, data-only, per-object, all DBs, roles, globals, pg_basebackup, pgBackRest incremental, PITR setup, restore
- Backup analysis with archive mode detection
- Log analyzer (paste log or ls -la output)
- PITR restore point creation
- Generated scripts with copy/save buttons
- Database size distribution analysis
- Archive mode and WAL status alerts
- Auto-generated backup, restore, and cron scripts
- Backup log parser
- Full FDW inventory (servers, mappings, foreign tables with column details)
- Create foreign servers, tables, user mappings via UI
- Import Foreign Schema with LIMIT TO
- Script All DDL (complete export with column OPTIONS)
- Renamed from "PouraDBA Monitoring Suite" to "DBA Coworker"
- AI Chat with live server context
- AI Auto-Fix with 7 issue types and one-click fix
- Query Optimizer (paste SQL → rewritten with indexes)
- Natural Language SQL Generator
- Incident Playbook Generator
- Migration Helper (ALTER TABLE with rollback)
- Documentation Generator (Runbook, Architecture, DR Plan)
- API key management
- Real-time sparkline graphs (6 metrics)
- EXPLAIN ANALYZE visual tree
- Query history (persistent, saved to disk)
- Multi-database switcher (dropdown in header)
- Health Report (8-point scoring)
[object Object]bug on interval columns (query_duration, txn_duration)
- 8 new monitoring tabs: Wait Events, File I/O, Objects, Functions, Maintenance, Extensions, Roles, Backup/Server
- Cancel/Kill buttons on Connections tab
- One-click VACUUM/ANALYZE/REINDEX on Maintenance tab
- Export CSV on every tab
- Server delete from edit dialog
- Removed pre-loaded servers — starts clean like pgAdmin
- "Register Server" welcome screen
- Server registration dialog
- Server registration with pgAdmin-style UI
- Fleet overview (scan all servers)
- 11 monitoring tabs (Overview, Connections, Databases, Tables, Indexes, Replication, Locks, Bloat, Slow Queries, Settings, SQL Editor)
- Auto-refresh (10s toggle)
- Connection test
- Dark theme