Documentation
Everything you need to build with HostBase
HostBase is compatible with the Supabase API — use @supabase/supabase-js, existing guides and libraries. Here you'll find the details specific to our platform.
Quickstart
Your first project and query in 5 minutes.
Migrate from Supabase
Move your database, users and files.
Next.js
App Router, SSR and cookie-based sessions.
Database
Postgres 17, REST, extensions and dashboard tools.
Edge Functions
Templates, deploys from the dashboard, API and MCP, secrets.
Point-in-time recovery
Restore your database to any second.
Branching
Preview environments and migration merges.
MCP server
Claude, Cursor and AI agents in your projects.
CLI
db push, functions deploy, gen types.
Getting started
- QuickstartCreate a project, grab the keys and run your first query in under 5 minutes.
- Migrating from SupabasePLMove a Supabase project to HostBase with pg_dump, pg_restore and two env vars.
- Connect dialogPLReady-made snippets for frameworks, ORMs, the pooler and MCP.
- Import z Supabase jednym kliknięciemPLKreator przenosi bazę, użytkowników Auth i pliki Storage z Supabase do HostBase.
- Keyboard shortcutsPLNavigate the dashboard without a mouse.
Frameworks
Products
- DatabasePostgres 17, extensions, direct connections and the PgBouncer pooler, auto-generated APIs.
- AuthenticationE-mail and password, magic links, OAuth, JWT sessions and RLS integration.
- StorageBuckets, uploads, signed URLs, the S3 protocol and file management in the dashboard.
- RealtimePLDatabase changes, broadcast and presence over WebSockets.
- Edge FunctionsServerless TypeScript (Deno) functions hosted next to your database — deployed from the dashboard, API or MCP.
- Historia zmian wierszyPLŚledzenie INSERT/UPDATE/DELETE w wybranych tabelach — wartości przed i po, autor zmiany, retencja.
- Doradca indeksówPLindex_advisor i HypoPG: sugestie indeksów dla wolnych zapytań, symulacja kosztu i budowa CONCURRENTLY.
- Partycjonowanie tabel (pg_partman)PLTabele dzielone po czasie lub ID, partycje tworzone z wyprzedzeniem, retencja przez pg_cron.
- Logowanie audytu (pgaudit)PLRejestrowanie instrukcji SQL z wybranych klas (READ, WRITE, DDL, ROLE…) w logu Postgresa.
- Testy bazy (pgTAP)PLTesty schematu, polityk RLS i funkcji w pgTAP — z panelu, CLI, API i na gałęziach podglądu z GitHuba.
- pg_repack i plpgsql_checkPLOdzyskiwanie miejsca po martwych wierszach bez blokowania tabeli i statyczna analiza funkcji PL/pgSQL.
- Transformacje obrazówPLSkalowanie, kadrowanie i WebP/AVIF w locie dla plików w Storage — zgodne z Supabase.
- Polskie wyszukiwanie pełnotekstowePLSłownik sjp.pl dla Postgres FTS: odmiana, stop-słowa, wariant bez ogonków, kolumna tsvector z indeksem GIN.
Integrations
- IntegrationsPLExtend your database with Postgres modules, wrappers and HostBase add-ons.
- Wrappers (FDW)PLQuery Stripe, Notion, S3 and more as Postgres tables.
- VaultPLEncrypted secrets inside your database.
- QueuesPLDurable message queues in Postgres with pgmq.
- GraphQLPLpg_graphql and the in-dashboard GraphiQL IDE.
- Add-onsPLConnection pooler (PgBouncer), cache (Valkey/Redis) and search (Meilisearch).
- App connectionsPLPer-app API credentials, redirect URLs and secrets for connecting external apps.
- Pakiety database.devPLInstalacja rozszerzeń SQL z rejestru database.dev przez pg_tle — przeglądanie, wersje, odinstalowanie.
- Workflowy z pgflowPLSilnik workflowów na Postgresie i Edge Functions: instalacja, worker, uruchamianie i podgląd przebiegów.
- Supabase Studio, Stripe Sync Engine i ElectricSQLPLAdd-ony HostBase: oryginalne Studio, synchronizacja Stripe do Postgresa i shapes ElectricSQL.
AI & tools
- Vectors & AIPLpgvector embeddings, semantic search and RAG.
- MCP serverConnect Claude, Cursor and other AI agents to HostBase through the Model Context Protocol.
- Management APIREST API for automation: organizations and projects, authenticated with a personal access token.
- CLIHostBase CLI: projects, migrations (db push), TypeScript types, Edge Functions, secrets, branches, backups and PITR from your terminal.
- Integracja z GitHubemPLPush wdraża migracje i Edge Functions, pull request tworzy gałąź bazy do podglądu.
Platform
- Monitoring & notificationsPLReports, logs, advisors, alerts and upgrade suggestions.
- BackupsPLDaily and manual backups, off-site copies, restore and download.
- Row Level SecurityPLProtect data with Postgres policies and auth.uid().
- BillingPLPlans, limits, compute sizes and invoices.
- RegionsWhere your data physically lives.
- MigrationsPLSchema migrations compatible with the Supabase CLI.
- PipelinesPLLogical replication to external Postgres, Debezium and other subscribers.
- API keys & JWT rotationPLanon and service_role keys, and rotating the JWT secret.
- Data APIPLPostgREST settings: exposed schemas, max rows and search path.
- Log drainsPLShip project logs to HTTP, Loki or Datadog.
- Compute — instance sizePLChoosing a Postgres instance size, with recommendations based on usage.
- Network restrictions (IP allowlist)PLWho can connect directly to the project's Postgres and pooler.
- Custom domainsPLYour project's API on your own domain, with an automatic certificate.
- Moving a project between regionsPLChange region (Warsaw ↔ Stockholm) without changing URLs or keys.
- Szablony projektówPLGotowe backendy: SaaS, blog, sklep, czat AI z RAG, czat Realtime, lista zadań.
- Repliki odczytuPLKopie bazy tylko do odczytu, synchronizowane strumieniowo — w tym samym lub innym regionie.
- Autoskalowanie computePLAutomatyczna zmiana rozmiaru instancji w ustalonych granicach.
- Point-in-time recoveryRestore your database to any second within the retention window — continuous WAL archiving.
- Database branchingSeparate database environments for testing and previews — schema only or with data, migrations merged back to production.
- Account securityPLMFA, sessions and the Trust Center.
- SSO dla firm (SAML 2.0 i OpenID Connect)PLLogowanie do panelu przez firmowego dostawcę tożsamości: Okta, Entra ID, Google Workspace, Keycloak i inni.
- Limity API (rate limiting)PLLimity żądań na IP lub globalnie dla REST, Auth, Storage i Edge Functions — HTTP 429 w bramce API.
- Edytor tabel: mapa PostGIS, walidacja JSON i dane testowePLMapa dla kolumn geometry/geography, ograniczenia JSON Schema (pg_jsonschema) i generator realistycznych danych.
- Generowanie typów: TypeScript, Zod, KyselyPLTypy generowane na żywo ze schematu bazy — w panelu, przez API i CLI.