发现优质的 AI Agent 技能
聚合 Claude Skills、LangChain、AutoGPT 等优质资源,助力开发者快速构建智能应用
PostgreSQL Optimization Workflow
来自 sickn33/antigravity-awesome-skills 技能
pgbouncer.ini
server_idle_timeout = 60 client_idle_timeout = 300 ``` Reference: [Connection Timeouts](https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-IDLE-IN-TRANSACTION-SESSION-TIMEOUT)
Section Definitions
This file defines the rule categories for Postgres best practices. Rules are automatically assigned to sections based on their filename prefix.
Writing Guidelines for Postgres Rules
This document provides guidelines for creating effective Postgres best practice rules that work well with AI agents and LLMs.
Postgres Best Practices
**Version 1.0.0** Supabase January 2026
Tech Stack
Set up the following tech stack: - **Rails ~8** with PostgreSQL - Server-side framework and database - **Inertia.js ~2.3** - Bridges Rails and React for SPA-like experience without API - **React ~19.2** - Frontend UI framework - **Vite ~5** - JavaScript bundler with HMR
For Postgres, use transactions instead of steps
engine.execute("INSERT INTO table VALUES (?)", data) ``` **Correct (using transaction):**
Claimable Postgres
Instant Postgres databases for local development, demos, prototyping, and test environments. No account required. Databases expire after 72 hours unless claimed to a Neon account.
PostgreSQL Job Queue
Production-ready job queue using PostgreSQL with priority scheduling, batch claiming, and progress tracking.
PostgreSQL State Management (Experimental)
This document describes how the OpenProse VM tracks execution state using a **PostgreSQL database**. This is an experimental alternative to file-based state (`filesystem.md`), SQLite state (`sqlite.md`), and in-context state (`in-context.md`).
PostgreSQL State Management (Experimental)
This document describes how the OpenProse VM tracks execution state using a **PostgreSQL database**. This is an experimental alternative to file-based state (`filesystem.md`), SQLite state (`sqlite.md`), and in-context state (`in-context.md`).
Supabase Vault — Enhanced Secret Storage
Replaces the local `secrets.json` vault with Supabase Vault. All OpenClaw API keys, tokens, and auth credentials are stored AES-256 encrypted in your Supabase Postgres database. Bootstrap credentials (the Supabase URL + service_role key needed to reach the vault) are encrypted locally using OS keychain or machine-derived AES-256-GCM.