sqloptima
Menu
View on GitHub
← All products

Observe SQL Server and PostgreSQL

SQL Monitoring

SQL Optima combines live engine telemetry with expert rules so DBAs can move from a symptom to the workload, query, configuration, or capacity issue behind it.

  • 14 PostgreSQL dashboards
  • 15 SQL Server dashboards
  • 100% self-hosted
View releases View repository
SQL Monitoring screenshot
Product screenshotCurrent SQL Server dashboard from the SQL Monitoring repository.

What it helps you do

A practical path from signal to action

01

Triage the estate

Use control-center dashboards for sessions, CPU, memory, I/O, waits, locks, storage, backups, and security.

02

Analyze expensive SQL

Investigate Query Store and pg_stat_statements workloads, regressions, plan instability, and EXPLAIN plans.

03

Apply DBA guidance

Use built-in rule evaluators, thresholds, forecasting, and remediation guidance to turn telemetry into action.

From the repository

Product facts

Platform
Go API and vanilla JavaScript SPA
Metrics store
PostgreSQL 16 with TimescaleDB
Credential protection
HashiCorp Vault Transit
Current release
0.5.0 in the repository documentation

Verified scope

Support and project status

Project status
Project
Engine coverage
SQL Server: Supported · PostgreSQL: Supported
Last reviewed
2026-09-27

Project evidence

Trust and maintenance links

LicenseMITDocumentationOpen on GitHubSecurityOpen on GitHubIssuesOpen on GitHub

How it works

Typical workflow

  1. Install the local stack

    Docker Compose starts the API, TimescaleDB, Vault, and schema bootstrap services.

  2. Register an instance

    Add SQL Server or PostgreSQL from the setup wizard and validate the monitoring permissions.

  3. Investigate and remediate

    Start with the engine dashboard, drill into waits or queries, then use the built-in DBA guidance.

Run it yourself

Requirements and quick start

Requirements

  • Docker Desktop or Docker Engine with Compose V2
  • Git or a repository release archive
  • Read-oriented monitoring permissions on each target database

Quick start

Windows PowerShell
irm https://raw.githubusercontent.com/rsharma155/sql_optima/main/install.ps1 | iex
macOS or Linux
curl -fsSL https://raw.githubusercontent.com/rsharma155/sql_optima/main/install.sh | bash

Source: repository README.md ↗. Check the repository for the latest security notes, configuration options, and release status.

Explore another sqloptima product or go straight to the source.

Browse productsOpen on GitHub ↗