One feature per post — what it does, how to use it, and what it doesn't do yet.
An MCP key you hand an agent isn't all-or-nothing. It carries one of three access levels, capped by what the workspace allows, and can be narrowed to named views with a role on each — so a key scoped to one table is refused every other table's data, reads included.
26 Aug 2026Verified 26 Aug 2026
Access tokens are stateless, so revoking one is usually a polite request that takes effect when it expires. Here's the approach that doesn't work, and the one we shipped.
21 Aug 2026Verified 21 Aug 2026
Paste one URL into Claude or ChatGPT and an agent can work in your workspace — after a consent screen, inside scopes that never reach your schema, and revocable in one click.
20 Aug 2026Verified 20 Aug 2026
Categories with a parent category, employees with a manager, comments replying to comments — one table, one foreign key pointing home. You can build it from the picker now, and read a whole chain of it in the grid.
28 Aug 2026Verified 28 Aug 2026
A widget decides how a value is typed in and drawn — a date picker, an email link, a currency reading. It sits on top of a plain database column, and the formatting it adds lives in the browser, so the API and the export still see the raw value underneath.
26 Aug 2026Verified 26 Aug 2026
A many-to-many in SchemaStack is a genuine join table — composite key, two cascading foreign keys — and when it carries columns of its own, a role or a rate, it stays a first-class table you drill through rather than a detail hidden from you.
26 Aug 2026Verified 27 Aug 2026
An address reads as one thing and stores as five. Display groups give you the single cell without giving up the columns underneath it — the query still sorts, filters and exports the parts.
24 Aug 2026Verified 24 Aug 2026
A validation rule that lives in a form protects the form. Attach it to the column instead and every writer gets the same answer — the REST API, the grid, the import, the Zap, the agent.
24 Aug 2026Verified 26 Aug 2026
Write an expression and a column appears in the grid — computed on every query, stored nowhere, with nothing to migrate and nothing that can go stale.
23 Aug 2026Verified 23 Aug 2026
A foreign key holds a number. Point a column at the relationship and the grid shows the related row's name, or a count of the rows on the far side, or several values at once — and it will walk more than one hop to get there.
23 Aug 2026Verified 27 Aug 2026
Before altering a column, SchemaStack counts the rows, classifies the operation against the engine you actually run, estimates how long it will take and names what it will lock — and while it runs, the API says 503 rather than hanging.
22 Aug 2026Verified 22 Aug 2026
Point SchemaStack at an existing Postgres or MySQL database and it reads the schema you already run — tables, columns, types, keys, indexes — then gets out of the way.
21 Aug 2026Verified 21 Aug 2026
SchemaStack isn't the only thing touching your database. Here's how it notices when the schema moved without it, what the report tells you, and what sync will and won't reconcile.
21 Aug 2026Verified 21 Aug 2026
Add a column in the grid and a real column appears in your database — with the migration previewed first, rows, locking behaviour, SQL and all.
20 Aug 2026Verified 20 Aug 2026
The grid updates the instant a row changes; a Zap finds out on its next poll. Both are correct, and knowing which is which decides what you should build on.
23 Aug 2026Verified 28 Aug 2026
Twelve filter operators in bracket notation, multi-field sorting against a whitelist, depth-capped relationship expansion and field selection — the full query surface, including the parts that behave badly.
22 Aug 2026Verified 26 Aug 2026
Every workspace publishes a full REST API generated from its schema — filtering, sorting, pagination, relationship expansion and an OpenAPI document — with no code generation step and nothing to deploy.
21 Aug 2026Verified 26 Aug 2026
Point a workspace at your Auth0, Clerk or Firebase and your end-users call the generated REST API with their own identities — row-level security narrows every query to their rows.
20 Aug 2026Verified 20 Aug 2026
You filtered, sorted three ways, hid four columns and widened two. A preset saves that whole arrangement — and shares it, so the answer to "how are you looking at this?" is a name instead of a screenshot.
24 Aug 2026Verified 24 Aug 2026
What it takes for a colleague's edit to land in your grid without a refresh — two scoped streams, a keepalive that outlives sleeping laptops, and the three tests that turned out to pass whether any of it worked or not.
24 Aug 2026Verified 24 Aug 2026
Two conditional style rules, one row, and the order you put them in decides the colour — plus the four places the styling engine quietly disagrees with the filters on your API.
23 Aug 2026Verified 23 Aug 2026
Guest links give a client, contractor or auditor live access to exactly one view — read or edit, time-limited, revocable, no account required.
20 Aug 2026Verified 20 Aug 2026
Imports only ever added, so re-importing a corrected export gave you everything twice. Name the columns that identify a row and the second import skips or corrects instead of duplicating.
28 Aug 2026Verified 28 Aug 2026
You can export a view to a CSV whenever you like — filtered, streamed by a worker, downloaded from a link only you can open. But it's a convenience, not the escape hatch, because the escape hatch is that the data was already in a Postgres database you own.
26 Aug 2026Verified 26 Aug 2026
SchemaStack has a Zapier integration — three triggers, two actions and a search — so a row in a database you own can start a workflow, or be what a workflow writes to.
23 Aug 2026Verified 28 Aug 2026
A CSV becomes typed SQL columns with real constraints — and the rows that don't fit are caught and named before they land, instead of becoming nulls you find in six months.
22 Aug 2026Verified 27 Aug 2026
Signups usually live inside whichever tool captured them. Put them in a database you own instead and every tool becomes downstream — replaceable without an export, queryable without asking.
23 Aug 2026Verified 23 Aug 2026
Every page on this site has a Markdown twin at the same address, the API surfaces are described in a machine-readable catalog, and authentication is published as a document an agent can follow — all generated at build time, so none of it can fall behind.
22 Aug 2026Verified 22 Aug 2026