1
Show HN: SSO for PostgreSQL Using OAuth2/OIDC
用OAuth2/OIDC为PostgreSQL实现单点登录，代理轻量、原生协议，一键集成Auth0等身份提供商
Article URL: https://github.com/sathwick-p/gprxy Comments URL: https://news.ycombinator.com/item?id=49094215 Points: 1 # Comments: 0
2
PGSimCity - How PostgreSQL Works
可视化模拟PostgreSQL引擎运行，直观理解数据库内部机制
Article URL: https://nikolays.github.io/PGSimCity/ Comments URL: https://news.ycombinator.com/item?id=49063754 Points: 264 # Comments: 34
3
How are you giving AI agents access to postgress?
AI代理访问数据库时，LLM直接生成SQL风险高，需要权衡定义操作与手动防护的平衡。
I mean we can either let llm generate sql but that's risky right or should we do defined operations? I mean for both reads and write. But whether it's…
4
Show HN: Kosh – a self-hosted personal finance app
自托管个人财务管理应用，数据隐私与完全掌控，轻松部署于服务器。
hi hn, i built kosh because i wanted to track my finances without giving a hosted service access to the data. it supports accounts, transactions, budg…
5
Show HN: PostgreSQL Now Supported in DBTrail
DBTrail 开源工具新增 PostgreSQL 支持，让你的数据库版本控制与回放更简单。
Article URL: https://github.com/dbtrail/dbtrail Comments URL: https://news.ycombinator.com/item?id=48926882 Points: 2 # Comments: 1
6
Start with A – Open-source, self-hosted investment research platform (BYOK AI)
开源自托管投资研究平台，自带AI助手，BYOK模式一键挖掘投资灵感。
Article URL: https://github.com/warlock20/StartWithA Comments URL: https://news.ycombinator.com/item?id=48832733 Points: 2 # Comments: 0
7
Show HN: Foundation, a different approach to software and AI
零拷贝、4KB控制缓冲+10-30ns调度，为AI应用打造的高性能底层内核。
Article URL: https://github.com/nmxmxh/foundation Comments URL: https://news.ycombinator.com/item?id=48785026 Points: 3 # Comments: 0
8
Show HN: Brume – Postgres pseudonymization that preserves FKs across tables
PostgreSQL假名化神器Brume，巧妙保留跨表外键关系，轻松实现数据脱敏
Article URL: https://brumeorg.github.io/ Comments URL: https://news.ycombinator.com/item?id=48773741 Points: 1 # Comments: 0
9
Show HN: Pglayers – PostgreSQL extensions as stackable Docker layers
80+ PostgreSQL 扩展打包成 Docker 层，免编译直接跑，数据库开发者的福音。
Article URL: https://github.com/pglayers/pglayers Comments URL: https://news.ycombinator.com/item?id=48749752 Points: 24 # Comments: 3
10
PostgreSQL-Compatible Databases for AI at Scale
AI项目选数据库别踩坑：PostgreSQL兼容可能是甜蜜陷阱，看清扩展性与架构债务再决定。
Article URL: https://www.cockroachlabs.com/blog/postgresql-compatible-databases-ai-scale/ Comments URL: https://news.ycombinator.com/item?id=48718811 …
11
Try AI Operators on PostgreSQL
在PostgreSQL上体验AI运算符，让数据库查询拥抱智能新能力。
Article URL: https://samtsql.com/ Comments URL: https://news.ycombinator.com/item?id=48601666 Points: 1 # Comments: 0
12
Show HN: PostgreSQL MCP Server with 135 tools for various purpose
PostgreSQL MCP服务器，内置135个工具，覆盖多种数据库操作场景。
Article URL: https://github.com/corporatepiyush/mcp-pg-rust Comments URL: https://news.ycombinator.com/item?id=48602101 Points: 2 # Comments: 0
13
Show HN: dbconform – stateless schema drift repair, no migration history
无需迁移历史，直接对比声明式Schema与数据库，自动生成修复SQL，终结混乱的数据库状态管理。
No Alembic. No migration files. No history table. dbconform compares your declared schema against your live database and generates the SQL to close th…
14
PostgreSQL 2200N Error: Causes and Solutions Complete Guide
在线XML内容验证工具，快速检测PostgreSQL 2200N错误，支持标签匹配与特殊字符转义检查，提升SQL XML数据质量。
PostgreSQL Error 2200N: invalid xml content PostgreSQL error 2200N: invalid xml content occurs when you attempt to insert or process malformed XML dat…
15
PostgreSQL 2200F Error: Causes and Solutions Complete Guide
详解PostgreSQL 2200F错误根源，提供正则函数与约束场景的即用解决方案，助你快速定位并修复零长度字符串问题。
PostgreSQL Error 2200F: Zero Length Character String PostgreSQL error 2200F: zero_length_character_string occurs when an empty string ( '' ) is passed…
16
pg_durable: Microsoft open sources in-database durable execution
微软开源pg_durable，将持久化执行模式嵌入PostgreSQL数据库，无需额外服务基础设施即可实现可靠工作流。
Article URL: https://github.com/microsoft/pg_durable Comments URL: https://news.ycombinator.com/item?id=48414367 Points: 189 # Comments: 42
17
Fuzzy Text Search in PostgreSQL: How Trigrams Make Computers "Almost Right"
用trigram让PostgreSQL实现"差不多对"的模糊文本搜索，从原理到实践一探究竟。
A deep dive into one of the most clever tricks in database engineering - explained so simply, your grandmother could follow along. The Problem: Comput…
18
How to set up PostgreSQL permissions for AI coding tools (Cursor, Claude, Copilot)
别再把数据库管理员权限直接给AI编码工具了，教你设置最小必要权限，安全又高效。
Most developers I talk to connect Cursor or Claude directly to their databases using a full admin connection string. Wether it's a local Docker databa…
19
Token Optimization Strategies for LLM-Based Oracle-to-PostgreSQL Migration
LLM驱动的Oracle到PostgreSQL迁移中，如何用Token优化策略降低成本提升效率？
arXiv:2605.28557v1 Announce Type: cross Abstract: LLMs are increasingly used for software modernization, code translation, and database migration. How…
20
Show HN: OAuth 2.0 framework for MCP servers
一键为MCP服务器集成OAuth 2.0设备授权流，保护工具访问并管理令牌。
Article URL: https://github.com/brooksmcmillin/mcp-authflow Comments URL: https://news.ycombinator.com/item?id=48296739 Points: 2 # Comments: 0