Zuvo Docs

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

Advanced guide
Amazon Cognito (Amplify)
Anonymous Sign-Ins
Auth
Auth architecture
Auth Audit Logs
Auth Hooks
Auth0
Before User Created Hook
Build a Social Auth App with Expo React Native
Clerk
Creating a Zuvo client for SSR
Custom Access Token Hook
Custom OAuth/OIDC Providers
Email Templates
Enable CAPTCHA Protection
Enterprise Single Sign-On
Error Codes
Firebase Auth
General configuration
Getting Started with OAuth 2.1 Server
Identities
Identity Linking
Implicit flow
JSON Web Token (JWT)
JWT Claims Reference
JWT Signing Keys
Login with Apple
Login with Azure (Microsoft)
Login with Bitbucket
Login with Discord
Login with Facebook
Login with Figma
Login with GitHub
Login with GitLab
Login with Google
Login with Kakao
Login with Keycloak
Login with LinkedIn
Login with Notion
Login with Slack
Login with Spotify
Login with Twitch
Login with X / Twitter
Login with Zoom
MFA Verification Hook
Migrating to the SSR package from Auth Helpers
Model Context Protocol (MCP) Authentication
Multi-Factor Authentication
Multi-Factor Authentication (Phone)
Multi-Factor Authentication (TOTP)
Native Mobile Deep Linking
OAuth 2.1 Flows
OAuth 2.1 Server
Passkey authentication
Password security
Password Verification Hook
Password-based Auth
Passwordless email logins
Phone Login
PKCE flow
Rate limits
Redirect URLs
Send Email Hook
Send emails with custom SMTP
Send SMS Hook
Server-Side Rendering
Sign in with Web3
Signing out
Single Sign-On with SAML 2.0 for Projects
Social Login
SSO and Social Login with WorkOS
Third-party auth
Token Security and Row Level Security
Use Zuvo Auth with Astro
Use Zuvo Auth with Next.js
Use Zuvo Auth with React
Use Zuvo Auth with React Native
User Management
User sessions
Users
Which package to use
WorkOS

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

Analytics Buckets
Analytics Buckets Limits
Analytics Buckets Pricing
Apache Spark
Bandwidth & Storage Egress
Cache Metrics
Copy Objects
Creating Analytics Buckets
Creating Buckets
Creating Vector Buckets
Custom Roles
Delete Objects
Download Objects
DuckDB
Error Codes
Iceberg Catalog
Limits
Logs
Ownership
Pricing
Purge CDN Cache
PyIceberg
Query with Postgres
Querying Vectors
Resumable Uploads
S3 Authentication
S3 Compatibility
S3 Uploads
Serving assets from Storage
Smart CDN
Standard Uploads
Storage
Storage Access Control
Storage Buckets
Storage CDN
Storage Helper Functions
Storage Image Transformations
Storage Optimizations
Storage Quickstart
Storing Vectors
The Storage Schema
Vector Bucket Limits
Vector Bucket Local Development
Vector Buckets
Working with Vector Indexes

Functions

Authorization headers
Background Tasks
Building a Discord Bot
Building a Telegram Bot
Building an MCP Server with mcp-lite
CAPTCHA support with Cloudflare Turnstile
CORS (Cross-Origin Resource Sharing) support for Invoking from the browser
Custom Auth Emails with React Email and Resend
Dart Edge
Deploy to Production
Development Environment
Development tips
Edge Functions
Edge Functions Architecture
Environment Variables
Error codes
Error Handling
File Storage
Function Configuration
Generate Images with Amazon Bedrock
Generating OG Images
Getting Started with Edge Functions
Getting Started with Edge Functions (Dashboard)
GitHub Actions
Handling Compressed Requests
Handling Routing in Functions
Handling Stripe Webhooks
Handling WebSockets
Image Manipulation
Integrating With Zuvo Auth
Integrating with Zuvo Database (Postgres)
Integrating with Zuvo Storage
Limits
Local Debugging
Logging
Managing dependencies
Monitoring with Sentry
Pricing
Rate Limiting Edge Functions
Recursive / Nested Function Calls
Regional Invocations
Resumable WebSockets with Edge Functions
Routing
Running AI Models
Scheduling Edge Functions
Securing Edge Functions
Semantic Search
Sending Emails
Sending Push Notifications
Slack Bot Mention Edge Function
Status codes
Streaming Speech with ElevenLabs
Taking Screenshots with Puppeteer
Testing your Edge Functions
Transcription Telegram Bot
Type-Safe SQL with Kysely
Upstash Redis
Using Wasm modules

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

Adding generative Q&A for your documentation
AI & Vectors
Amazon Bedrock
Automatic embeddings
Building ChatGPT plugins
Choosing a Client
Choosing your Compute Add-on
Concepts
Creating and managing collections
Engineering for Scale
Face similarity search
Generate Embeddings
Generate image captions using Hugging Face
Generating OpenAI GPT3 completions
Going to Production
Google Colab
HNSW indexes
Hugging Face Inference API
Hybrid search
Image Search with OpenAI CLIP
IVFFlat indexes
Keyword search
LangChain
Learn how to integrate Zuvo with LlamaIndex, a data framework for your LLM applications.
Python client
RAG with Permissions
Roboflow
Semantic Image Search with Amazon Titan
Semantic search
Semantic Text Deduplication
Structured and Unstructured
Vector columns
Vector indexes
Vector search with Next.js and OpenAI
Video Search with Mixpeek Multimodal Embeddings

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

About billing on Zuvo
Access Control
Account Setup
Available regions
AWS Marketplace
AWS Marketplace FAQ
Backup and Restore using the CLI
Billing FAQ
Choosing the Right SSO Login Flow
Compute and Disk
Control your costs
Credits
Custom Domains
Database Backups
Dedicated IPv4 Address for Ingress
Deleting Your Project
Enable SSO for Your Organization
Enforce MFA on Organization
Enterprise-Managed Authentication for MCP
Get set up for billing
Getting Started
Getting started with Read Replicas
HIPAA Projects
Invoices
Manage Advanced MFA Phone usage
Manage Branching usage
Manage Compute usage
Manage Custom Domain usage
Manage Disk IOPS usage
Manage Disk size usage
Manage Disk Throughput usage
Manage Edge Function Invocations usage
Manage Egress usage
Manage IPv4 usage
Manage Log Drain usage
Manage Logs Ingest usage
Manage Logs Query usage
Manage Logs usage
Manage Monthly Active SSO Users usage
Manage Monthly Active Third-Party Users usage
Manage Monthly Active Users usage
Manage Pipelines usage
Manage Point-in-Time Recovery usage
Manage Read Replica usage
Manage Realtime Messages usage
Manage Realtime Peak Connections usage
Manage Storage Image Transformations usage
Manage Storage size usage
Manage your subscription
Manage your subscription
Manage your usage
Migrate from Amazon RDS to Zuvo
Migrate from Auth0 to Zuvo Auth
Migrate from Firebase Auth to Zuvo
Migrate from Firebase Firestore to Zuvo
Migrate from Heroku to Zuvo
Migrate from MSSQL to Zuvo
Migrate from MySQL to Zuvo
Migrate from Neon to Zuvo
Migrate from Postgres to Zuvo
Migrate from Render to Zuvo
Migrate from Vercel Postgres to Zuvo
Migrated from Firebase Storage to Zuvo
Migrating to Zuvo
Migrating within Zuvo
Multi-factor Authentication
Multiple SSO Providers
Network Restrictions
Performance Tuning
Permissions
Personal Access Tokens
Postgres connection logging
Postgres SSL Enforcement
PrivateLink
Project Pausing
Project Transfers
Read Replicas
Restore Dashboard backup
Restore to a new project
Set Up SSO with Azure AD
Set Up SSO with Google Workspace
Set Up SSO with Okta
SSO Testing and Best Practices
Temporary access
Understanding Database and Disk Size
Understanding SSO Login Flows
Upgrading
Your monthly invoice
Zuvo 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

pgmq: Queues

pgmq: Managed queues in Postgres

See the Zuvo Queues docs.