Guides Open Studio

Getting Started

API keys
Architecture
Build a Product Management Android App with Jetpack Compose
Build a User Management App with Angular
Build a User Management App with Expo React Native
Build a User Management App with Flutter
Build a User Management App with Ionic Angular
Build a User Management App with Ionic React
Build a User Management App with Ionic Vue
Build a User Management App with Next.js
Build a User Management App with Nuxt 3
Build a User Management App with React
Build a User Management App with RedwoodJS
Build a User Management App with Refine
Build a User Management App with SolidJS
Build a User Management App with Svelte
Build a User Management App with SvelteKit
Build a User Management App with Swift and SwiftUI
Build a User Management App with Vue 3
Features
Getting Started
Migrating to publishable and secret API keys
Use Zuvo with Android Kotlin
Use Zuvo with Astro
Use Zuvo with Expo React Native
Use Zuvo with Flutter
Use Zuvo with Hono
Use Zuvo with iOS and SwiftUI
Use Zuvo with Laravel
Use Zuvo with Next.js
Use Zuvo with Nuxt
Use Zuvo with Python
Use Zuvo with React
Use Zuvo with RedwoodJS
Use Zuvo with Refine
Use Zuvo with Ruby on Rails
Use Zuvo with SolidJS
Use Zuvo with Spring Boot
Use Zuvo with SvelteKit
Use Zuvo with TanStack Start
Use Zuvo with Vue

Auth

Database

BigQuery destination
Cascade Deletes
ClickHouse destination
Column Level Security
Connect to your database
Connecting to Metabase
Connecting with Beekeeper Studio
Connecting with DBeaver
Connecting with pgAdmin
Connecting with PSQL
Connection management
Customizing Postgres configs
Database
Database configuration
Database debugging and monitoring
Database Functions
Database replication
Database Webhooks
Debugging performance issues
Deleting data and dropping objects safely
Drizzle
Drop all tables in a Postgres schema
DuckLake destination
Event Triggers
Foreign Data Wrappers
Full Text Search
http: RESTful Client
HypoPG: Hypothetical indexes
Import data into Zuvo
index_advisor: query optimization
Managing Enums in Postgres
Managing Indexes in Postgres
Managing JSON and unstructured data
Manual replication FAQ
Manual replication monitoring
Migrate from TimescaleDB to pg_partman
Monitor pipeline status
OrioleDB Overview
Partitioning tables
Performance and Security Advisors
pg_cron: Schedule Recurring Jobs with Cron Syntax in Postgres
pg_graphql: GraphQL for Postgres
pg_hashids: Short UIDs
pg_jsonschema: JSON Schema Validation
pg_net: Async Networking
pg_partman: partition management
pg_plan_filter: Restrict Total Cost
pg_repack: Physical storage optimization and maintenance
pg_stat_statements: Query Performance Monitoring
PGAudit: Postgres Auditing
pgjwt: JSON Web Tokens
pgmq: Queues
PGroonga: Multilingual Full Text Search
pgrouting: Geospatial Routing
pgsodium (pending deprecation): Encryption Features
pgTAP: Unit Testing
pgvector: Embeddings and vector similarity
Pipelines FAQ
plpgsql_check: PL/pgSQL Linter
plv8: JavaScript Language
PostGIS: Geo queries
Postgres Extensions Overview
Postgres Roles
Postgres Triggers
postgres_fdw
Postgres.js
Print Postgres version
Prisma
Query Optimization
Querying Joins and Nested tables
Replicate to another Postgres database using Logical Replication
Roles, superuser access and unsupported operations
Row Level Security
Row Level Security performance
RUM: improved inverted index for full-text search based on GIN index
Securing your data
Select first row for each group in Postgres
Serverless Drivers
Set up manual replication
Set up Pipelines
Snowflake destination
Supavisor
Tables and Data
Testing Your Database
Timeouts
timescaledb: Time-Series data
Troubleshooting prisma errors
uuid-ossp: Unique Identifiers
Vault
Working With Arrays

Storage

Functions

Realtime

Benchmarks
Broadcast
Getting Started with Realtime
Listening to Postgres Changes with Flutter
Operational Error Codes
Postgres Changes
Presence
Realtime
Realtime Architecture
Realtime Authorization
Realtime Concepts
Realtime Limits
Realtime Pricing
Realtime Protocol
Realtime Reports
Settings
Subscribing to Database Changes
Using Realtime Presence with Flutter
Using Realtime with Next.js

Ai

Ai Tools

Agent Skills
AI Prompts
AI Tools
Deploy MCP servers
Zuvo MCP Server
Zuvo Plugin for AI Coding Agents

Local Development

Advanced pgTAP Testing
Customizing email templates
Database migrations
Declarative database schemas
Local Development & CLI
Local development workflow
Managing config and secrets
Restoring a downloaded backup locally
Seeding your database
Testing and linting
Testing Overview
Zuvo CLI

Deployment

Branching
Branching via the dashboard
Configuration
Database Migrations
Deployment & Branching
GitHub integration
Integrations
Managing Environments
Maturity Model
Production Checklist
Shared Responsibility Model
Terraform Provider reference
Troubleshooting
Working with branches

Platform

Integrations

Build a Zuvo Integration
Integrations
Partner Catalog
Scopes for your OAuth App
Stripe Projects
Vercel Marketplace
Zuvo for Platforms
Zuvo Partner Integration Guide

Monitoring And Debugging

Advanced Log Querying and Filtering
Client-side tracing
Debugging guide
Log Drains
Logging
Logs field reference
Metrics API
Metrics API with Grafana Cloud
Metrics API with Prometheus & Grafana (self-hosted)
Monitoring and Debugging
Reports
Sentry integration
Vendor-agnostic Metrics API setup

Queues

API
Consuming Zuvo Queue Messages with Edge Functions
Expose Queues for local and self-hosted Zuvo
PGMQ Extension
Quickstart
Zuvo Queues

Cron

Cron
Install
Quickstart

Api

Auto-generated documentation
Build an API route in less than 2 minutes.
Client Libraries
Converting SQL to JavaScript API
Creating API Routes
Custom Claims & Role-based Access Control (RBAC)
Data REST API
Error Codes
Generating Python Types
Generating TypeScript Types
Handling errors in `supabase-js`
How to do automatic retries with `supabase-js`
Securing your API
SQL to REST API Translator
Using Custom Schemas

Resources

Glossary
Resources

Security

GDPR compliance and Zuvo
HIPAA Compliance and Zuvo
Platform Audit Logs
Secure configuration of Zuvo platform
Secure configuration of Zuvo products
Securing npm installs
Security testing of your Zuvo projects
SOC 2 Compliance and Zuvo
Zuvo Security

Cli

Local Dev with CLI

Self Hosting

Accessing Postgres
Configure Phone Login & MFA
Configure Reverse Proxy and HTTPS
Configure S3 Storage
Configure SAML SSO
Configure Social Login (OAuth) Providers
Copy Storage Objects from Platform
Custom Email Templates
Custom Postgres Extensions
Enabling MCP Server Access
Envoy API Gateway
New API Keys and Asymmetric Authentication
Remove Superuser Access from Studio
Restore a Platform Project to Self-Hosted
Self-Hosted Functions
Self-Hosting
Self-Hosting with Docker
Update Your Self-Hosted Deployment
Upgrade to Postgres 17

Zuvo Studio zuvodev.com

Guide

pg_cron: Schedule Recurring Jobs with Cron Syntax in Postgres

pg_cron: schedule recurring Jobs with cron syntax in Postgres.

See the Zuvo Cron docs.