Oxynote: an open source internal wiki with live PostgreSQL query charts

From: Oxynote via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: Oxynote: an open source internal wiki with live PostgreSQL query charts
Date: 2026-10-28 11:27:17
Message-ID: 179318683778.1250.11815868123785986669@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-announce

Oxynote is a new open-source (Apache-2.0) internal wiki for engineering teams. A page can include a chart that runs its own query against Prometheus, PostgreSQL, MySQL, or MariaDB right next to the explanatory text, and changes to important pages go through a draft, a diff, and approval, like a pull request.

Internal docs go stale because people open them only when something breaks. Live data gives the team a reason to open a page every day, and pages read daily stay up to date.

How it works with PostgreSQL:

* Live Metrics blocks run SQL against your PostgreSQL databases and show the result as a time series, bar chart or gauge.
* Queries can use Grafana-style macros such as `$__timeFilter`, `$__timeGroup` and `$__timeFrom`, so existing dashboard queries carry over.
* Oxynote only connects to read-only data sources: a role or database with `default_transaction_read_only` enabled, or a standby. Every session also runs in read-only mode.
* Oxynote stores its own data in PostgreSQL 18, which is embedded in the all-in-one Docker image.

A typical use is a runbook that shows replication lag or slow query counts next to the steps for handling them, so the chart and its explanation are reviewed together.

Oxynote is available from:

* [Source and install instructions](https://github.com/oxynote/oxynote)
* [Latest release](https://github.com/oxynote/oxynote/releases)

Browse pgsql-announce by date

  From Date Subject
Next Message Estuary via PostgreSQL Announce 2026-10-28 11:27:31 Estuary Expands PostgreSQL CDC with Targeted Backfills and Scalable Discovery
Previous Message SCaLE Conference via PostgreSQL Announce 2026-10-28 11:27:04 PostgreSQL@SCaLE24x CfP closing soon on Nov 1, 2027