<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/sources/postgres/best-of/2025" -->

---
title: Best PostgreSQL posts of 2025 | daily.dev
description: The most upvoted PostgreSQL posts of 2025, curated by the daily.dev community.
canonical: https://daily.dev/sources/postgres/best-of/2025
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:url: https://daily.dev/sources/postgres/best-of/2025
og:type: website
og:site_name: daily.dev
og:title: Best PostgreSQL posts of 2025 | daily.dev
og:description: The most upvoted PostgreSQL posts of 2025, curated by the daily.dev community.
og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph
---

# Best of PostgreSQL — 2025

1. 1  
[](/posts/pg-ai-query-ai-powered-sql-generation-query-analysis-for-postgresql-mzlrrodqe "pg_ai_query — AI-powered SQL generation & query analysis for PostgreSQL")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
1m read time • Nov 23, 2025  
### pg\_ai\_query — AI-powered SQL generation & query analysis for PostgreSQL  
pg\_ai\_query is a new PostgreSQL extension that enables AI-powered SQL query generation and analysis directly within Postgres. Developers can generate SQL queries from natural language descriptions and get AI-assisted explanations of query execution plans. The extension supports PostgreSQL 14+ and aims to streamline query development by eliminating the need to switch between tools.

+5  
62  
3
2. 2  
[](/posts/autobase-2-5-0-released-rji6cf5ws "Autobase 2.5.0 released")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
1m read time • Nov 24, 2025  
### Autobase 2.5.0 released  
Autobase 2.5.0 introduces Expert Mode to its UI, enabling advanced cluster configuration options for experienced users. Key features include a YAML editor for custom parameters, updated cloud provider pricing and instance specifications (Hetzner ARM instances, 4th-gen Intel on AWS/GCP), configurable IOPS and throughput for AWS EBS volumes, and Ansible 12 compatibility. Autobase is an open-source tool for deploying and managing highly available PostgreSQL clusters, automating tasks like deployment, failover, backups, and scaling without requiring deep DBA expertise.

+5  
36  
1
3. 3  
[](/posts/postgresql-pgmoneta-0-16-gjg2xckmy "PostgreSQL: pgmoneta 0.16")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
1m read time • Apr 23, 2025  
### PostgreSQL: pgmoneta 0.16  
pgmoneta version 0.16.0 is now available, offering new features such as incremental backup support for PostgreSQL 17+, advanced filtering for pgmoneta-walinfo, Prometheus/HTTPS support, Docker/podman images, and various enhancements and bug fixes. pgmoneta provides comprehensive backup and restore solutions, including full and incremental backups, compression options, AES encryption, symlink support, WAL shipping, hot standby, remote management, offline mode, TLS v1.2+ support, daemon mode, and user vault.

+4  
22
4. 4  
[](/posts/postgresql-18-1-17-7-16-11-15-15-14-20-and-13-23-released--wwybaugkn "PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 Released!")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
3m read time • Nov 13, 2025  
### PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 Released!  
PostgreSQL has released security updates across all supported versions (18.1, 17.7, 16.11, 15.15, 14.20, and 13.23), addressing two security vulnerabilities and over 50 bugs. The first vulnerability allows unauthorized denial of service through CREATE STATISTICS commands, while the second involves integer wraparound in libpq that can cause memory corruption. PostgreSQL 13 reaches end-of-life with this final release, and users should plan upgrades to supported versions.

+3  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/6f33cd15292e8020dca3b53c6385264d?_a=AQAEulh)  
22
5. 5  
[](/posts/autobase-2-3-0-released-gfltobpqh "Autobase 2.3.0 released")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
2m read time • Jul 21, 2025  
### Autobase 2.3.0 released  
Autobase 2.3.0 introduces dark theme for the console UI, ability to import existing PostgreSQL clusters, export functionality to Ansible inventory, refactored Ansible Collection integration, and AWS Network Load Balancer support. This open-source DBaaS platform simplifies PostgreSQL cluster deployment and management with automated operations including failover, backups, and scaling.

+4  
17  
2
6. 6  
[](/posts/pg-ai-query-v0-1-0-first-stable-release-with-multi-model-ai-for-postgresql-w8k83thlo "pg_ai_query v0.1.0 — First stable release with multi-model AI for PostgreSQL")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
1m read time • Dec 13, 2025  
### pg\_ai\_query v0.1.0 — First stable release with multi-model AI for PostgreSQL  
pg\_ai\_query v0.1.0 is now stable, bringing AI-powered query development directly into PostgreSQL. The extension generates SQL from natural language, provides AI-interpreted EXPLAIN ANALYZE results, and offers automated index and rewrite recommendations. It supports multiple AI providers including OpenAI, Anthropic, Google Gemini, OpenAI-compatible APIs like OpenRouter, and local models through Ollama. The extension works with PostgreSQL 14+ on Linux and macOS, enabling developers to choose between cloud models or fully local inference while staying within the Postgres environment.

+4  
16  
1
7. 7  
[](/posts/postgresql-18-beta-2-released--uylgh7vfm "PostgreSQL 18 Beta 2 Released!")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
3m read time • Jul 17, 2025  
### PostgreSQL 18 Beta 2 Released!  
PostgreSQL 18 Beta 2 is now available for download, containing previews of all features planned for the final release. The PostgreSQL Global Development Group encourages community testing to identify bugs and issues before the stable release expected around September/October 2025\. Key fixes in Beta 2 include improvements to pg\_get\_process\_memory\_contexts() function, pg\_dump handling for complex table names, and changes to default statistics behavior. Users can upgrade using standard major version upgrade strategies like pg\_upgrade or pg\_dump/pg\_restore, though production use is not recommended for beta versions.

+4  
![Post Cover image](https://media.daily.dev/image/upload/t_mobile_feed/v1/posts/6f33cd15292e8020dca3b53c6385264d?_a=AQAEulh)  
16  
1
8. 8  
[](/posts/pgformatter-v5-8-has-been-released-ymcnluwdg "pgFormatter v5.8 has been released")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
2m read time • Sep 14, 2025  
### pgFormatter v5.8 has been released  
pgFormatter v5.8 introduces improved formatting for INSERT statements, now distinguishing between single and multiple value formats with different indentation styles. The release also fixes indentation issues in DO blocks and includes various user-reported bug fixes and improvements.

+3  
12
9. 9  
[](/posts/pgscv-0-15-1-released--7kyx3c2y9 "pgSCV 0.15.1 released!")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
1m read time • Dec 30, 2025  
### pgSCV 0.15.1 released!  
pgSCV 0.15.1 is now available, a Prometheus-compatible monitoring agent and metrics exporter for PostgreSQL environments. This release includes new functionality and bug fixes between versions 0.15.0 and 0.15.1, though specific features aren't detailed in the announcement. The tool aims to provide a unified solution for collecting metrics from PostgreSQL and related services.

+4  
11
10. 10  
[](/posts/postgresql-pgexporter-0-7-ynh1g7wwd "PostgreSQL: pgexporter 0.7")  
[![postgres's profile](https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/8dab534748a94108858df41b7ef7fe86)](/sources/[source]/best-of/[year])  
1m read time • Sep 14, 2025  
### PostgreSQL: pgexporter 0.7  
pgexporter version 0.7.0 has been released with improvements to core metrics and new features. This Prometheus exporter for PostgreSQL includes extension support developed as part of a Google Summer of Code project. The tool helps monitor PostgreSQL databases by exporting metrics to Prometheus.

+4  
11

[See all PostgreSQL archives](/sources/postgres/best-of)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/postgres/best-of/2025#page","url":"https://daily.dev/sources/postgres/best-of/2025","name":"Best PostgreSQL Posts of 2025","description":"The most upvoted PostgreSQL posts of 2025, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/postgres/best-of/2025#items","numberOfItems":10,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/pg-ai-query-ai-powered-sql-generation-query-analysis-for-postgresql-mzlrrodqe","name":"pg_ai_query — AI-powered SQL generation \u0026 query analysis for PostgreSQL"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/autobase-2-5-0-released-rji6cf5ws","name":"Autobase 2.5.0 released"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/postgresql-pgmoneta-0-16-gjg2xckmy","name":"PostgreSQL: pgmoneta 0.16"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/postgresql-18-1-17-7-16-11-15-15-14-20-and-13-23-released--wwybaugkn","name":"PostgreSQL 18.1, 17.7, 16.11, 15.15, 14.20, and 13.23 Released!"},{"@type":"ListItem","position":5,"url":"https://daily.dev/posts/autobase-2-3-0-released-gfltobpqh","name":"Autobase 2.3.0 released"},{"@type":"ListItem","position":6,"url":"https://daily.dev/posts/pg-ai-query-v0-1-0-first-stable-release-with-multi-model-ai-for-postgresql-w8k83thlo","name":"pg_ai_query v0.1.0 — First stable release with multi-model AI for PostgreSQL"},{"@type":"ListItem","position":7,"url":"https://daily.dev/posts/postgresql-18-beta-2-released--uylgh7vfm","name":"PostgreSQL 18 Beta 2 Released!"},{"@type":"ListItem","position":8,"url":"https://daily.dev/posts/pgformatter-v5-8-has-been-released-ymcnluwdg","name":"pgFormatter v5.8 has been released"},{"@type":"ListItem","position":9,"url":"https://daily.dev/posts/pgscv-0-15-1-released--7kyx3c2y9","name":"pgSCV 0.15.1 released!"},{"@type":"ListItem","position":10,"url":"https://daily.dev/posts/postgresql-pgexporter-0-7-ynh1g7wwd","name":"PostgreSQL: pgexporter 0.7"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"PostgreSQL","item":"https://daily.dev/sources/postgres"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/postgres/best-of"},{"@type":"ListItem","position":5,"name":"2025"}]}]}
```

