Skip to content

postgresai 0.14.0

Latest
Latest

Choose a tag to compare

View all tags
@NikolayS NikolayS released this 23 Jan 01:14
· 18 commits to main since this release
0.14.0
eac6799

AI-native PostgreSQL observability — monitoring, health checks, and root cause analysis for engineers and AI agents.

Highlights

0.14 brings direct PostgreSQL health checks via postgresai checkup, Claude Code plugin (/pgai), first-class Supabase support, and MCP tools for AI-assisted database management. The CLI was migrated to Bun for faster performance. Grafana dashboards now display query texts in Top-N charts (Dashboard 2), version/build timestamps, and new index analysis panels showing size, reads/hits in bytes. This release also delivers dozens of fixes and improvements.

Summary

This release includes 72 changes.

🚀 New Features and optimizations

  • dashboard: add query texts to TopN charts and table with smart truncation (!162)
  • CLI: add markdown output and improve checkup UX (!188)
  • CLI: embed checkup dictionary from API at build time (!179)
  • add unprepare-db command and pg_stat_statements to prepare-db (!177)
  • add databaseUrl to prepare-db --supabase JSON output (!175)
  • add MCP tools for action items (!172)
  • CLI: add Supabase mode and JSON output for prepare-db command (!173)
  • H001: add decision tree recommendations for invalid indexes (!166)
  • monitoring: Display version and build timestamp in Grafana Self-monitoring dashboard (!146)
  • MCP: add create_issue tool for issue creation via MCP (!127)
  • dashboards: unify panel titles and units across Grafana dashboards (!131)
  • reporter: add index_definition to H001 invalid indexes report (!134)
  • CLI: add express checkup command with direct PostgreSQL health checks + fix H004 and A003 (!115)
  • Add new single-index panels for size, reads/hits (bytes), add 50 and 100 options for Top-N of table and index analysis (!110)
  • prepare-db: add helper functions for generic plan collection, with optional HypoPG index; wrap each prepare-db step in begin/commit block; introduce "postgres_ai" schema (!117)
  • Add JSON schemas for checkup report outputs + tests (!98)
  • CLI: implement postgresai init to create DB role and grant permissions (!100)
  • Add Postgres version to report data (!96)
  • reporter: add database exclusion support (!95)
  • Support Amazon Managed Prometheus (!167)
  • adjust table&index dashboards: panel widths and bloat ordering (!143)
  • Hourly monitoring reports improvements + new K008 check (!124)
  • Daily JSON reports with hourly snapshots of pgss and ASH data (!97)
  • ignore estimated bloat for relations < 1 MiB (!106)
  • Embed index_pilot component (!102)

Fixes and optimizations

  • support pg_stat_statements in extensions schema (Supabase) (!190)
  • CLI: recognize --no-upload option, decouple --json from upload (!183)
  • CLI: append Supabase project ref to pooler username (!176)
  • use postgres_ai schema for pg_statistic + add --provider flag for Supabase (!174)
  • deps: update gunicorn and requests to address security vulnerabilities (!159)
  • CLI: use CLI version instead of stale .env tag (!153)
  • pgai: resolve postgresai/cli export instead of package.json (!151)
  • grafana: enable stacking for top-N index panels (!150)
  • CLI: macOS compatibility, cleanup, and image tag handling (!147)
  • CLI: mon clean now properly removes containers and volumes (!144)
  • CLI: pass Grafana password directly to Docker during local-install (!140)
  • docker: macOS compatibility for monitoring containers (!138)
  • CLI: resolve --api-key option being ignored in mon local-install (!137)
  • prepare-db: add SQL injection protection to explain_generic (!121)
  • CLI: resolve SQL directory at runtime for bundled CLI (!133)
  • CLI: pass api_url to UI for OAuth to ensure same backend is used (!129)
  • clean up HTTP error messages for CLI commands (!123)
  • replace Bun.serve with Node.js http module in auth-server (!122)
  • Get true lock_timeout and statement_timeout (!105)
  • CLI sslmode=prefer behavior, CI publish improvements, and schema fixes (!108)
  • Add resource limits and rename self-monitoring components (!178)
  • Reduce pgwatch log verbosity to error level (!185)

Refactoring

  • migrate CLI from Node.js to Bun (!118)
  • move auth-related commands under auth group (!119)
  • improve CLI commands and authentication flow (!113)
  • Restructure README with SaaS-first onboarding flow (!192)
  • modernize README with AI-native positioning, demos, and Claude Code plugin /pgai (!187)

Contributors

Thank you to all who contributed to this release!

  • Thomas Cave
  • Dmitry Fomin
  • Denis Morozov
  • Dementii Priadko
  • Nikolay Samokhvalov
  • Bogdan Tsechoev

Ideas and proposed changes are accepted on both GitLab and GitHub:

Getting Started

  • SaaS (recommended): sign up at console.postgres.ai and connect your database in minutes.
  • Self-hosted: install the CLI with npm install -g postgresai and run postgresai checkup <connection-string> for instant health checks, or postgresai mon local-install --demo for the full monitoring stack.
Assets 2
Loading