rivetsql-postgres 0.1.18

PostgreSQL plugin for Rivet SQL

rivetsql-postgres

PostgreSQL engine and catalog plugin for Rivet.

---

Full PostgreSQL support with async connection pooling, server-side cursors for streaming large result sets, and all seven write strategies. Uses psycopg3 under the hood.

---

⚡ Install

pip install rivetsql[postgres]

---

🔧 Configuration

# profiles.yaml
default:
  engines:
    - name: pg
      type: postgres
      options:
        statement_timeout: 60000
        pool_min_size: 2
        pool_max_size: 10
      catalogs: [warehouse]
  catalogs:
    - name: warehouse
      type: postgres
      options:
        conninfo: "host=localhost dbname=analytics"

---

✨ Capabilities

Feature	Supported
Compute engine	✅
Catalog	✅
Read	✅
Write	✅
List tables	✅
Schema introspection	✅
Test connection	✅
Cross-joint adapter	✅

---

📚 Documentation

Full docs at rivetsql.github.io/rivet/plugins/postgres

---

Part of the Rivet framework.