The interval AWR can't see.

1-second ASH live, no agent on the server, up to a year of history on your machine. Now and any past moment, on the same screens.

Free forever, no card. Pro with a 30-day trial inside the app. Windows and Linux.

Oracle, PostgreSQL, MySQL & ClickHouse

Oracle 19cOracle 21cOracle 23aiOracle 26aiPostgreSQL 13PostgreSQL 14PostgreSQL 15PostgreSQL 16PostgreSQL 17PostgreSQL 18MySQL 8.0 · 8.4 · 9.xClickHouse 24.8+

Monitoring Features

Everything you need for complete database observability

It answers before it shows: what is outside this database's normal right now, load by wait class against the CPUs, latency on its usual band, and the limits sorted by how close they are.

Health Dashboard
New in 1.12.93

Answers first, and the SQL of every action in view

Every screen now says what is wrong before it shows the numbers, and LAB256 acts on the database, showing the statement before it runs.

  • A Free plan, no key

    LAB256 opens without a licence: 2 connections, the last 24 hours on the time bar and commands shown to copy. Pro's 30-day trial is requested inside the app.

  • MySQL 8.0, 8.4 and 9.x

    Dashboard, Performance Hub, sessions, locks, SQL and SQL Tuning, storage, memory, security, jobs and parameters, with a monitoring user LAB256 hands you ready-made.

  • A verdict on top of the screen

    Dashboard, SQL investigation, Jobs, Storage, Database information, Security and Health Check open with what is outside the normal, each finding naming what to look at. A check that could not be read says so; it is never drawn as OK.

  • Act, with the SQL in view

    Cancel a statement, add a datafile, rebuild an index, fix a plan as a baseline, gather statistics, create an index invisible first. Every command is shown as the statement it sends, before and after. A connection can be read-only, production starts that way, and every action is journalled.

  • A flight recorder and one time bar

    Every open connection is recorded whichever screen is in front, for up to a year. Drag the time bar and the screens answer for that window; compare with yesterday or last week, pin notes, and export the window as CSV.

  • ClickHouse, as it is configured

    Running queries, the query log, parts, merges, mutations and replicas, errors, and the server's own dashboards. The time bar reads the history ClickHouse keeps in its system tables.

Retention is a setting: the hourly grain keeps 365 days by default. SQL text is never recorded unless you switch it on.

Simplify your database management

Specialized tools for every aspect of database administration.

From the plan to the index, measured

Index recommendations read from the plan's own predicates, hint variants ranked by measured elapsed time, column statistics beside the estimate they explain, and the index created invisible first, when you decide.

3 screenshots

Ready to see every second of your database?

Free forever, no card; Pro with a 30-day trial. See what the 15-minute snapshot is hiding.

Download free

Why DBAs choose LAB256

Features that make a difference in day-to-day database administration.

    • AWR keeps a snapshot every 15 minutes. LAB256 reads the live ASH second by second and records vitals every 10 seconds by default, with top SQL and sessions every minute, on your machine.

      The interval between snapshots
    • A flight recorder writes every open connection into an encrypted local history at four grains. Drag the time bar to any moment and the Dashboard, Performance Hub, Sessions, Locks, Storage, Memory, Health, Jobs, errors and SQL answer for that window.

      Up to a year of time travel
    • A JDBC connection, and a read-only user is enough to monitor. Nothing installed on the database server; the queries are light and the refresh interval is yours to set.

      Low impact, no agent
    • Create custom SQL monitors with automatic alerts. Use the template library or write your own queries.

      Customizable Alerts
    • Native support for multi-instance RAC environments and Data Guard standby monitoring.

      Oracle RAC & Data Guard
    • PostgreSQL 13 to 18 with sessions, pg_stat_statements, locks, vacuum, replication and WAL. MySQL 8.0, 8.4 and 9.x with sessions, digests, locks and metadata locks, InnoDB and replication. ClickHouse 24.8 and later with running queries, the query log, parts, merges and replicas.

      PostgreSQL, MySQL and ClickHouse

Where LAB256 fits with what you already have

It does not replace OEM or AWR. It covers the interval between snapshots and keeps what they discard.

FeatureLAB256AWR / OEM
History grainLive ASH every second; recorded every 10 s for a day, by the minute for a month, by the hour for up to a year15-minute snapshots; ASH at 10 s for 8 days, by default
Agent on the serverNone: JDBC, and a read-only user is enough to monitorOEM Agent installed on every host
Where the data livesOn your computer, encryptedCentral repository
PostgreSQL, MySQL and ClickHouseYes: PostgreSQL 13 to 18, MySQL 8.0+, ClickHouse 24.8+No
Going back in timeOne time bar, every screenReports by period
LicensingFree on Free; Pro per person, Team per user; never per databaseDiagnostics Pack per processor

V$ACTIVE_SESSION_HISTORY and DBA_HIST_* views require the Oracle Diagnostics Pack on the monitored database. LAB256 checks on connection whether the pack is available and flags on screen when a panel depends on it.

Get Started in Minutes

Download, install and open: Free works without a key. Nothing on the database server.

1

Download

A signed MSI for Windows, a .deb for Debian and Ubuntu. Nothing is asked before the download.

2

Install

Run the installer: about 150 MB, with its own Java runtime and nothing else to install.

3

Open and connect

LAB256 opens on Free, with no key and no sign-up. Connect with a read-only user; LAB256 hands you the script that creates one. To try Pro, ask for the 30 days inside the app.

4

Explore

Watch now live, and drag the time bar into the past.

Plans and Pricing

Free is free, with no time limit. Pro has a 30-day trial with no card and a 30-day guarantee. No agent on the server, a read-only user and every statement shown.

Free

To try LAB256 on your own database

Free

no time limit, no card

  • 1 machine
  • 2 connections
  • Last 24 h of history
  • Statements shown to copy, not run on the database
Download free

Pro

For the DBA who looks after production

—

per year

  • Up to 3 of your machines
  • Unlimited connections
  • Up to 1 year of local history
  • Actions on the database, with the SQL before and after
  • Email support within 1 business day

30-day guarantee: a full refund if it is not for you.

Buy Proor try it free for 30 days, no card

Team

For DBA teams and public bodies

—

per user per year

Minimum 3 users

  • Everything in Pro, one licence per user
  • Priority 8x5 support
  • Offline activation by QR, for restricted networks
  • Purchase orders accepted
  • Over 20 users, by quote
Request a quote

In reais: Pix, boleto or card. In dollars: card. Prices follow the currency of the billing country.

Download

Windows and Linux, 64-bit. Free opens without a key; Pro has a 30-day trial inside the app.

Frequently asked questions

If you can't find what you're looking for, email our support team and we'll get back to you shortly.

    • Which database versions are supported?

      Oracle Database 19c, 21c, 23ai and 26ai, including RAC and Data Guard; 12.2 and 18c connect with some screens limited. PostgreSQL 13 to 18. MySQL 8.0, 8.4 LTS and 9.x (5.7 and MariaDB are not supported). ClickHouse 24.8 and later.

    • Do I need to install anything on the database server?

      No. LAB256 is agentless: it connects over JDBC directly to your Oracle, PostgreSQL, MySQL or ClickHouse database, and a read-only user is enough to monitor. The impact on the server is a few light queries against the performance views, at the interval you choose.

    • How does the trial period work?

      The trial offers 30 days with all features enabled and unlimited connections. No credit card required.

    • What PostgreSQL features are supported?

      Active sessions and what they wait on, query performance via pg_stat_statements, locks and blocking chains, vacuum and bloat, transaction ID age, replication, WAL and replication slots, storage and custom alerts.

    • What privileges are required?

      To monitor: on Oracle, read access to the dictionary (SELECT ANY DICTIONARY, SELECT_CATALOG_ROLE) and EXECUTE on DBMS_METADATA to read DDL; on PostgreSQL, the pg_monitor role and pg_stat_statements; on MySQL, PROCESS, REPLICATION CLIENT and read access to performance_schema and a few tables of the mysql schema; on ClickHouse, read access to the system tables. LAB256 shows a ready-made script for a dedicated monitoring user. Actions such as ending a session need their own privilege, and an action the user cannot take is dimmed with the reason.

    • Does LAB256 change anything in my database?

      Only when you confirm it. Monitoring only reads. Each action (cancel a statement, add a datafile, rebuild an index, gather statistics, fix a plan, create an index) opens a confirmation that shows the exact statement, and that statement is what runs and what goes into the journal. A connection marked read-only runs nothing, and connections tagged production start that way.

    • Where is data stored?

      What LAB256 reads from your databases is stored on your computer, in a history file encrypted at rest; SQL text only if you switch it on. What the application sends to us is the licence check, the update check and, unless you turn it off, usage data. Never database contents, SQL, results or connection names. The Security page lists it field by field.

    • Does it work with cloud databases?

      Yes. LAB256 works with any database it can reach over the network: on-premises, Oracle Cloud, AWS RDS, Azure Database, Google Cloud SQL and other managed services, as long as the monitoring user can read the views LAB256 queries.

    • What does LAB256 show for ClickHouse?

      What runs now and what ran (per query, from the query log), parts, merges, mutations and replicas, errors, the server's metrics and its own dashboards, and users and privileges. The time bar reads the history ClickHouse keeps in its system tables. What ClickHouse does not have, such as an SGA or sampled ASH, is dimmed in the menu with the reason. Requires ClickHouse 24.8 or later.

    • How does it compare to Oracle Enterprise Manager?

      LAB256 complements OEM: 1-second resolution between the 15-minute AWR snapshots, a local history you can scrub through on every screen, and nothing installed on the server. It also monitors PostgreSQL, which OEM does not. The comparison table sits just above the pricing.

    • Does it support monitoring multiple databases?

      Yes. Pro, Team and the trial monitor unlimited Oracle, PostgreSQL, MySQL and ClickHouse connections at once, with quick switching between them; Free opens 2. The licence is per person (Pro, up to 3 of their machines) or per user (Team), never per database.

    • What about technical support?

      Email support in Portuguese, English and Spanish, on business days from 9am to 6pm (Brasília), with an answer within one business day on Pro. Team is first in the queue (8x5). Free includes no support.