Export Overview
TalkingSchema exports your schema in two ways: standard exports from the toolbar (SQL, DBML, JSON, images, live deploy) and AI copilot exports generated inside the conversation thread (Prisma, Drizzle, TypeScript/Zod, OpenAPI, GraphQL, SQLAlchemy, TypeORM, and any other format the AI can produce). One-click file download for AI-generated outputs coming soon
Standard Exports
Access via the Export button in the top toolbar.
| Format | Description | Guide |
|---|---|---|
| SQL DDL | CREATE TABLE statements for PostgreSQL, MySQL, SQLite, MSSQL | SQL Export |
| DBML | Database Markup Language — compatible with schema-as-code (DBML friendly) tooling | DBML Export |
| JSON | Full schema model for automation and CI/CD pipelines | JSON Export |
| Image | PNG, SVG, PDF for documentation and presentations | Image Export |
| Deploy to Database | Execute schema directly against Supabase or Neon | Deploy to Database |
SQL dialects
- PostgreSQL — ENUM types, UUID, JSONB, TIMESTAMPTZ, SERIAL
- MySQL — ENGINE=InnoDB, AUTO_INCREMENT, ENUM columns
- SQLite — simplified, portable syntax
- MSSQL — Microsoft SQL Server with IDENTITY columns
AI Copilot Exports
Ask the AI copilot in the conversation panel to generate any of the following. The output is returned as a formatted code block — copy directly or use one-click file download coming soon
| Format | What you get | Guide |
|---|---|---|
| Prisma | Complete schema.prisma with models, @relation, enums, @@index | Prisma Export |
| Drizzle ORM | TypeScript pgTable definitions, relations(), inferred types | Drizzle Export |
| TypeScript & Zod | Interfaces, Zod insert/update/select schemas for API validation | TypeScript & Zod Export |
| OpenAPI | OpenAPI 3.1 YAML with CRUD paths, schemas, enums, and auth | OpenAPI Export |
| GraphQL | SDL with types, queries, mutations, input types, connections | GraphQL Export |
| SQLAlchemy | Python 2.0 ORM models with mapped_column() and relationship() | SQLAlchemy Export |
| TypeORM | Entity classes with decorators for NestJS and Node.js | TypeORM Export |
| Flyway migration | Versioned .sql migration files with rollback instructions | Migrations |
| Liquibase changeSet | XML changeSet with rollback elements | CI/CD Migrations |
| Alembic migration | Python upgrade() / downgrade() functions | Migrations |
The AI copilot can generate any format not listed above — ask in plain language: "Export this schema as Hibernate Java entities" or "Generate a Django models.py for this schema."
How to Access Export
Toolbar exports (SQL, DBML, JSON, Image, Deploy)
- Open a schema in TalkingSchema
- Click Export in the top-right toolbar
- Select your format from the dropdown
- Download or copy the output
AI copilot exports (Prisma, Drizzle, OpenAPI, etc.)
- Open your schema — the AI has full context of the current ERD
- In the chat panel, ask for the format you need:
- "Generate a schema.prisma for this ERD"
- "Export as Drizzle ORM TypeScript definitions"
- "Create an OpenAPI 3.1 spec with CRUD endpoints"
- The AI returns formatted output in the conversation
- Copy the code block — or use one-click download coming soon