Roadmap

SchemaStack is under active development. Here's what's available today and what's coming next.

Available Now

Core Platform

• Visual entity management — define entities, columns, and relationships through the Admin UI
• Spreadsheet-style data editing — Excel-like interface with inline editing, sorting, and filtering
• Auto-generated REST API — full CRUD with OpenAPI/Swagger documentation per workspace
• Real-time collaboration — live updates via SSE when team members edit data simultaneously
• Your data, always — SchemaStack connects to your database. Your data never leaves your infrastructure. We only store metadata (entity definitions, views, permissions). Learn more

Data Platform

• Filters & sorting — filter by any column with 9+ operators, multi-column sorting
• Presets — save and share filter/sort/column configurations with private, team, or public visibility
• Bulk operations — multi-row editing, export, and deletion with progress tracking
• Relationship navigation — browse and edit related entities inline, add columns from related tables
• Activity feed — real-time log of who changed what, when — undockable into a floating, draggable window

Schema & Validation

• Column types — text, number, boolean, date, timestamp, and more
• Computed columns — derived values from SQL expressions, calculated at query time
• Database indexes — create and manage single-column, composite, and unique indexes
• Constraints — not null, unique, min/max length, regex patterns, check expressions
• Schema drift detection — compare entity definitions against the live database
• Migration impact prediction — see whether a schema change will be instant, brief, or blocking before applying it

Access Control

• Organizations & workspaces — multi-tenant structure with isolated databases
• Role-based permissions — organization-level (Owner, Admin, Member) and workspace-level (Admin, Editor, Viewer)
• View-level access — control who can see and edit specific views
• API keys — scoped to workspaces with read-only or read-write permissions

Security

• Two-factor authentication — TOTP-based 2FA with recovery codes
• Session management — view and revoke active sessions
• Audit logging — track changes across the platform

AI Integration

• MCP server — expose your workspace as a Model Context Protocol server, so AI assistants (Claude, ChatGPT, Copilot, etc.) can browse schemas, query data, create records, and manage schema through natural conversation. Learn more

Integrations

• Zapier — connect your data to 7,000+ apps with triggers, actions, and searches via the native SchemaStack Zapier app. Learn more

Coming Soon

• Member presence — see who's online in your organisation. Active members are shown in member lists and updated in real-time via SSE on login, logout, and session expiry
• View Designer — design your entire view schema in one go. Instead of adding columns one at a time, define all columns — names, types, and constraints — in a single table-style editor, similar to database clients like pgAdmin or DBeaver. Reorder columns by dragging, set primary keys, nullable flags, and defaults before saving. Works for both new views and bulk-editing columns on existing views
• Visual relationship builder — drag-and-drop relationship creation
• Migration history — version tracking with rollback support
• Comments & annotations — discuss data inline
• Notifications — configurable alerts on changes that matter to you
• Career notifications — subscribe on the careers page to get notified when new positions open up

Managed Database Hosting

Coming in a future release

Two managed hosting options are planned, so you can choose the level of infrastructure management that fits your team.

Managed RDS

For teams who don't want to deal with database setup and administration. SchemaStack provisions and manages an AWS RDS instance on your behalf:

• One-click provisioning — SchemaStack creates a fully configured PostgreSQL (or MySQL) instance with optimized settings, proper security groups, VPC configuration, and encryption at rest.
• Right-sized infrastructure — instance type and storage selected based on your workload, with recommendations as you grow.
• Automated maintenance — minor version upgrades, patching, and parameter tuning handled by SchemaStack.
• Daily backups — RDS automated backups with configurable retention.
• Costs included — AWS infrastructure costs are bundled into your monthly SchemaStack subscription. No surprise bills.

You still own your data — SchemaStack manages the infrastructure, but the database is dedicated to your organization and can be migrated out at any time.

Enterprise: ZFS-Backed Hosting

For teams managing mission-critical, large-scale databases. ZFS-backed infrastructure enables capabilities that aren't possible with traditional database hosting:

• Instant cloning — create a full copy of your production database in seconds, regardless of size. A 5 TB database clones as fast as a 5 MB one, thanks to ZFS copy-on-write snapshots.
• Safe schema migration testing — before applying a schema change to production, test it on a live clone with real data. See exactly what will happen — execution time, lock impact, potential errors — without any risk to production.
• Risk-based execution — SchemaStack assesses each migration's risk level. Critical changes (large tables, destructive operations) require clone testing first. Low-risk changes can be applied directly.
• Tested rollbacks — roll back schema changes with confidence. Rollback scripts are validated on a clone before touching production.
• Hourly automated backups — ZFS snapshots provide instant restore to any hourly checkpoint with zero performance impact.
• SSO integration — SAML/OIDC for enterprise identity providers.
• Dedicated support

How It Works

Your database is replicated to SchemaStack's ZFS infrastructure via streaming replication. The replication stays in sync continuously, so clones always reflect near-real-time production data.

Your Database (AWS RDS, self-hosted, etc.)
    │
    │  Streaming replication
    ▼
SchemaStack ZFS Infrastructure
    ├── Live replica (continuously synced)
    ├── Hourly snapshots (point-in-time backups)
    └── Instant clones (for migration testing)
         └── Test migration → review results → apply to production

Cloning pauses replication for less than a second to take a consistent snapshot, then resumes immediately.

Hosting Comparison

Feature	Bring Your Own DB	Managed RDS	Enterprise ZFS
Database setup	You manage	SchemaStack provisions	SchemaStack provisions
Security groups & VPC	You manage	Configured for you	Configured for you
Database tuning	You manage	Optimized defaults	Optimized defaults
Backups	Self-managed	Daily (RDS automated)	Hourly (ZFS snapshots)
Point-in-time restore	—	RDS restore	Instant (any hourly checkpoint)
Schema migration testing	Direct to production	Direct to production	Clone-tested first
Migration rollback	Manual	Manual	Tested on clone
Instant database cloning	—	—	Seconds, any size
Infrastructure costs	Your AWS bill	Included in subscription	Included in subscription
SSO	—	—	SAML / OIDC
Support	Standard	Standard	Dedicated

Schema Templates

Instead of building your database from scratch, start from a proven structure. When creating a workspace, pick a template and get a fully structured database with entities, relationships, and pre-configured views — then customize to fit your needs.

Available Templates

Online Store — 10 entities including products, categories, shopping carts, orders, payments, customers, addresses, and reviews. Pre-configured views for product catalog, order management, and inventory tracking.

CRM — contacts, companies, deals, activities, tasks, and notes. Relationships between contacts and companies, deal pipelines, and activity tracking.

Project Management — projects, tasks, milestones, time entries, and team members. Task assignment, time tracking, and milestone views.

Image Gallery — albums, images, tags, and metadata. Media organization with tagging and album views.

Content Management — posts, categories, tags, authors, comments, and media. Blog-ready with moderation support and content organization.

Inventory — products, warehouses, stock levels, suppliers, purchase orders, receipts, and shipments. Multi-warehouse inventory tracking.

What's Included

Each template comes with:

• Entities with standard fields, appropriate types, and constraints
• Relationships between entities (one-to-many, many-to-many)
• Pre-configured views for common workflows
• Permissions — role-based access out of the box
• Optional sample data — see how the template looks with real data

Template Marketplace

Later, SchemaStack will support community-contributed templates. Share your own database designs, browse templates by industry, and install with one click.

Integration Guides

Step-by-step guides for connecting your auto-generated Workspace API to popular external services:

• Jotform — submit form responses directly into your workspace tables
• Make (Integromat) — build multi-step automations with your workspace data
• Google Sheets — sync workspace data to/from spreadsheets
• n8n — self-hosted workflow automation with your API
• Power Automate — Microsoft ecosystem integration

Each guide will walk through authentication (API keys), endpoint configuration, field mapping, and common recipes.

Database Integration Guides

Step-by-step guides for connecting SchemaStack to popular database providers. Each guide will cover connection setup, security considerations, and provider-specific tips.

• Supabase — connect to your Supabase PostgreSQL database
• Neon — serverless PostgreSQL with branching support
• Railway — managed PostgreSQL and MySQL deployments
• PlanetScale — MySQL-compatible serverless database
• Render — managed PostgreSQL instances
• AWS RDS — Amazon's managed PostgreSQL and MySQL
• Google Cloud SQL — managed databases on Google Cloud
• Azure Database — managed PostgreSQL and MySQL on Azure
• DigitalOcean Managed Databases — simple managed PostgreSQL and MySQL

Each guide will walk through obtaining connection credentials, configuring the workspace database settings, and verifying the connection.

Future

• Workspace & organisation slug renaming — allow changing slugs after creation, with automatic URL redirects and real-time SSE reconnection across all open sessions

• Webhooks — get notified on data changes programmatically

• Export/import — CSV, JSON, and more

• Custom widgets — extend the data platform with custom column renderers

• Advanced analytics — dashboards and reporting on your data

---

Feedback

Have a feature request? We'd love to hear from you. Reach out via GitHub.