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

Schema & Validation

• Column types — text, number, boolean, date, timestamp, and more
• Constraints — not null, unique, min/max length, regex patterns, check expressions
• Schema drift detection — compare entity definitions against the live database

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

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
• Computed columns — derived values from expressions
• 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

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:

• Zapier — trigger workflows when data changes, create rows from other apps
• 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.

MCP Server

Expose SchemaStack as a Model Context Protocol server, so AI assistants (Claude, ChatGPT, Copilot, etc.) can interact with your workspaces directly.

Data API

Let AI assistants read and write your workspace data:

• Query data — ask questions about your workspace data in natural language
• Create and update rows — write data through structured tool calls
• Filter and sort — AI can use the full query API to find specific records
• Bulk operations — update or delete multiple rows in one request

Metadata API

Let AI assistants design and manage your schema:

• Browse entities and columns — understand your full data model
• Create entities — describe what you need and let AI generate the schema
• Add columns and constraints — modify entity structure through natural conversation
• Manage views — create, configure, and share views
• Define relationships — set up entity relationships by describing how your data connects

How It Works

• Schema-aware — the MCP server exposes entity definitions, column types, constraints, and relationships, so AI tools understand your data structure before acting on it
• Permission-scoped — MCP access respects the same role-based permissions. A read-only API key can query data but not modify schema.
• Both APIs in one server — data and metadata are both available, so an AI assistant can create a new entity, add columns, set up constraints, and then populate it with data — all in one conversation

This turns every SchemaStack workspace into an AI-ready data platform — no custom integration code needed.

Future

• OAuth2 for Workspace API — authenticate against the auto-generated REST API using OAuth2 flows, in addition to API keys
• 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.