Tusk

A k9s-style terminal UI for real-time PostgreSQL monitoring and management. This is Not a database client, it's a tool for observing and acting on live database activity.

Features

• Live views — Queries, transactions, sessions, locks, tables, indexes with 2s auto-refresh
• Rules engine — Define policy rules in YAML using CEL expressions that evaluate against live database state
• Violation tracking — Audit log of rule violations with timestamped event lifecycle (detected → action → cooldown → closed)
• Auto Remediation — Automatically take actions on rule violations based on defined policies
• Split-pane detail views — Query detail with formatted SQL, transaction detail with query history, lock detail with blocker/blocked side-by-side
• Interactive Activity pane — Shows lock contention and rule violations per PID; Enter on a blocking PID navigates to its detail
• Tab navigation — Arrow keys cycle views, Tab cycles panes within detail views
• Column sorting — Shift+letter toggles sort on any column
• Filtering — / to filter any view, persists visually until cleared with Esc

Install

From source:

go install github.com/fraser-isbester/tusk/cmd/tusk@latest

Pre-built binaries: download from GitHub Releases.

Usage

# Direct connection
tusk 'postgres://user:pass@localhost:5432/mydb'

# Using a profile
tusk -P production

Configuration

~/.config/tusk/config.yaml

default_profile: dev

profiles:
  dev:
    url: "postgres://postgres:postgres@localhost:5432/mydb?sslmode=disable"
    rules:
      - name: kill-idle-in-txn
        resource: transaction
        when: "state == 'idle in transaction' && xact_duration > duration('5m')"
        action: terminate
        cooldown: 5m
        dry_run: true

      - name: long-queries
        resource: query
        when: "state == 'active' && duration > duration('30s')"
        action: cancel
        cooldown: 1m
        dry_run: true

  production:
    host: db.example.com
    port: 5432
    user: monitor
    password: 'secret'
    database: prod
    readonly: true
    rules:
      - name: idle-in-txn-5m
        resource: transaction
        when: "state == 'idle in transaction' && xact_duration > duration('5m')"
        action: terminate
        cooldown: 5m
        dry_run: true

Rule fields

Field	Description
resource	query, transaction, or lock
when	CEL expression evaluated against the resource fields
action	terminate, cancel, or log
cooldown	Minimum interval between action firings per PID
dry_run	Record violations but don't execute the action
readonly	Profile-level: forces all rules to dry-run

CEL expression fields

Query: pid, user, app, database, state, duration, wait_event_type, wait_event, query, blocked_by, query_id, route, controller, action_name, framework

Transaction: pid, user, app, database, state, xact_duration, query_duration, query, lock_count

Lock: blocked_pid, blocking_pid, blocked_user, blocking_user, blocked_app, blocking_app, lock_type, mode, wait_duration

Views

Command	Description
:queries	Active queries with duration, wait events, blocking info
:transactions	Active transactions sorted by age with lock counts
:sessions	Connections grouped by user, app, state
:tables	Table sizes, row counts, dead tuple %, vacuum stats
:locks	Blocked/blocking lock pairs
:indexes	Index scan counts and sizes
:rules	Configured rules with violation counts
:violations	Violation audit log with event timeline

Key bindings

Key	Action
← →	Switch views
:	Command prompt
/	Filter
Tab	Cycle panes in detail view
Enter	Drill into detail / fire action
Esc	Back / clear filter
Shift+letter	Sort by column
c	Cancel query (in query detail)
t	Terminate backend (in query/transaction detail)
q	Quit

Development

task db:up        # Start local Postgres in Docker
task run          # Build and run against local dev DB
task loadtest     # Generate realistic load (queries, transactions, locks, idle-in-txn)

Testing

task test         # Run all tests with Ginkgo
task test:cover   # Run tests with coverage report