Studio

Studio Schema

Admin surface for the 88 universal nodes, discriminators, and custom fields.

5 top capabilities75 featuresFrom pyd_product_taxonomy

What it is

Studio Schema — in one paragraph.

Studio Schema for Product Graph is the live database-schema explorer inside Pyramyd Studio. It introspects the production Postgres cluster on demand using information_schema and pg_catalog, and renders every table as a ReactFlow node with primary-key, foreign-key, and unique badges, cardinality glyphs, and category colors. The canvas supports ten-plus layout algorithms covering Dagre top-to-bottom and left-to-right plus eight ELK families, free-text and category and focus-hop filters, a deep-link share URL scheme, Hocuspocus-backed presence and live cursors, and an embed mode for iframing. On top of the canvas it stacks twenty-six capabilities including a rule-driven lint engine with eight built-in plus four team-convention rules and a server-backed fix queue, a thousand-row read-only SQL runner with EXPLAIN ANALYZE plan-tree rendering and saved templates, six AI tools backed by the configured LLM provider for categorization, natural-language-to-SQL, suggestions, table docs drafting, slow-query explanation, and auto-foreign-key detection, a fifteen-format codegen covering DBML, Prisma, Drizzle, SQL dialects, GraphQL, Markdown, JSON Schema, OpenAPI, DOT, Zod, Mermaid, and CSV, a drag-and-drop SQL and DBML importer with six starter templates, a docs editor and zipped docs-site export, a conservative ADD-only migration generator, an FK cycle breaker, a per-column profiler, slow-query and connection-pool dashboards, and an extras explorer for views, functions, triggers, policies, extensions, roles, and grants. Persistence spans five server tables plus per-user localStorage. Four scheduled CI workflows handle per-commit snapshot capture, daily digest emails, scheduled docs and SCHEMA.md regeneration, and pull-request drift checks. Eight APEX and Copilot tools make the entire surface natural-language-addressable.

Top 5 capabilities

The most-built-out capability set.

Each capability is the parent of dozens of typed features in the production taxonomy. Hover any feature in Studio to drill into the underlying nodes.

Import and Export

20 features

Import and Export for Product Graph serves the codegen dispatcher that produces fifteen output formats including DBML, Prisma, Drizzle, Postgres, MySQL, SQLite, and SQL Server DDL, GraphQL, JSON Schema, OpenAPI, DOT, Zod, Mermaid, Markdown, and CSV, hosts the drag-and-drop SQL and DBML importer with six starter templates, exports a preferences bundle, and packages the docs site into a downloadable zip.

SQL Tooling

16 features

SQL Tooling for Product Graph serves the read-only SQL runner with a server-side validator that strips comments and rejects anything but SELECT, WITH, and EXPLAIN statements, applies a thousand-row cap and a ten-second statement timeout, renders EXPLAIN ANALYZE output as a plan tree with hot-node highlighting, exports CSV in-browser, persists query history and templates, generates mock data for chosen tables, emits migration SQL, scaffolds CRUD route stubs, and lets administrative roles bypass RLS for read-only diagnostics.

Lint and Quality

14 features

Lint and Quality for Product Graph runs eight built-in lint rules covering no primary key, duplicate column, FK type mismatch, nullable FK without default, likely missing FK, circular FK, orphan table, and wide table, plus four team-convention example rules, surfaces severity controls through a Lint Rules dialog backed by both localStorage and schema_lint_prefs, and exposes a registerSchemaLintRule entry point for additional pluggable rules.

Snapshots and History

13 features

Snapshots and History for Product Graph captures live introspection payloads into schema_snapshots with author and tag metadata, supports manual capture from the toolbar plus a scheduled cron capture and a daily email digest cron, lets testers pick any two snapshots and render a markdown diff report, and broadcasts diff summaries through chat webhooks when SCHEMA_WEBHOOK_URL is configured.

Layouts and Algorithms

12 features

Layouts and Algorithms for Product Graph dispatches to Dagre top-to-bottom and left-to-right for fast Sugiyama hierarchies and to ELK for eight alternative families covering layered, mrtree, force, radial, stress, spore overlap, rectpacking, disco, and box. Layouts run inside a Web Worker so the UI stays responsive, and the final positions map is persisted per-graph to localStorage so user-arranged layouts survive reloads.