🌌 FlexORM

FlexORM is an all-in-one database toolkit that helps you (1) work with your database in any programming language, (2) create and run migrations, and (3) view your data in a web browser. It is a single executable called flexorm.

⚠️ FlexORM is currently experimental, unstable software undergoing heavily development - it is not (yet) intended for production use cases.

✨ Features

📄 Define your schema in plain, simple JSON (with IntelliSense, thanks to JSON schemas).

Eliminates learning custom DSLs and installing extra VSCode extensions.

🚀 Generate portable, lightweight, type-safe clients for any programming language directly from your schema.

Eliminates illegible type errors, heavy runtimes, slow Rust engines, and language lock-in.

🛡️ Validate everything that goes into your database by default.

Eliminates extra data validation libraries and manually writing validation logic.

🔄 Generate migrations automatically and apply them to your database.

Eliminates "the library I love doesn't have a migration engine with all the features I need for production."

👀 View your data in your web browser with FlexORM Studio.

Eliminates "I have no idea what's in my database."

---

🎯 Why FlexORM?

🧰 All-In-One Toolkit: Use your database types, manage and run your migrations, validate your data, and generate your database client in a single, unified workflow, letting you ship blazingly fast.

💡 Single Source of Truth: One schema drives validation, migrations, and clients across every programming language.

🌍 True Language Freedom: Generate native clients for any language and database driver, eliminating being locked into a single ecosystem.

📝 Simple Schema Format: Define your database structure in clean, readable JSON instead of learning yet another DSL and installing another VSCode extension.

⚡ Zero Runtime Overhead: Emitted clients have no bundled engines or heavy abstractions—just pure, performant native code that uses a database driver of your choosing.

🔒 Validation by Default: Automatic validation ensures data integrity before it ever reaches your database, catching errors before they hit your database.

🚫 Predictable Errors: Clear, local, and understandable errors—no thousand-line generic type explosions—that ruin your DX. FlexORM generates straightforward, readable clients.

Feature	FlexORM	Prisma	TypeORM	Sequelize	SQLAlchemy	Diesel	Drizzle
Schema-first	✅	✅	❌	❌	❌	❌	❌
Multi-language support	✅	❌	❌	❌	❌	❌	❌
Auto migration generation	✅	✅	✅	✅	✅	❌	✅
Simple JSON schema	✅	❌	❌	❌	❌	❌	❌
Built-in validation	✅	✅	✅	✅	❌	❌	⚠️
Type-safe queries	✅	✅	✅	❌	❌	✅	✅
No heavy backend	✅	❌	✅	✅	✅	✅	✅
Client code generation	✅	✅	❌	❌	❌	❌	❌

🚀 Roadmap

v0.1.0

• clientgen base
  • Add select method to client
  • Add insert method to client
• migrate base
  • Generate simple migrations automatically
  • Migrate up and down
• cli base
  • generate command
  • migrations up/down/create commands
  • studio command
• studio base
  • view data in a table

v0.2.0

• Add update method to client
• Add delete method to client
• Ensure select, update, insert, delete methods will allow for subqueries later on in development
• Add joins
  • inner join
  • left join
  • right join
  • full join
• Add preliminary tests
• Integrate testing pipeline into GitHub Actions

v0.3.0

• Add more column types
  • smallint
  • bigint
  • serial
  • smallserial
  • bigserial
  • boolean
  • varchar
  • char
  • numeric
  • real
  • double precision
  • json
  • jsonb
  • uuid
  • time
  • date
  • interval
  • point
  • line
  • enum
• Add Java support

v0.4.0

• Add more column types
  • email (custom)
  • phone number (custom)
  • vector (pgvector)
• Add constraints
  • nullable (default nullable = false)
  • unique (default unique = false)
• Add indexes
• Enhance FlexORM Studio with advanced features
  • Data visualization, filtering, and sorting
  • Edit cells

v0.5.0

• Implement relations
  • One-to-many relationships
  • Many-to-many relationships
• Make migrator prompt developer for renames vs deletes

Future Plans

• Add support for more programming languages
  • Python
  • Go
  • Ruby
  • PHP
  • C#
  • Java
• Add support for more database drivers and systems
  • PostgreSQL
  • MySQL
  • SQLite
  • Serverless databases
• Allow migration scripts to be written in any programming language beyond SQL
• Add tests