The ultimate Object Relational Mapper for Node.js, Bun and Deno, offering seamless integration with a variety of popular databases. Orange ORM supports both TypeScript and JavaScript, including both CommonJS and ECMAScript.
Key Features
- Rich Querying Model: Orange provides a powerful and intuitive querying model, making it easy to retrieve, filter, and manipulate data from your databases.
- Active Record: With a concise and expressive syntax, Orange enables you to interact with your database using the Active Record Pattern.
- No Code Generation Required: Enjoy full IntelliSense, even in table mappings, without the need for cumbersome code generation.
- TypeScript and JavaScript Support: Orange fully supports both TypeScript and JavaScript, allowing you to leverage the benefits of static typing and modern ECMAScript features.
- Works in the Browser: You can securely use Orange in the browser by utilizing the Express.js or Hono plugin, which serves to safeguard sensitive database credentials from exposure at the client level and protect against SQL injection. This method mirrors a traditional REST API, augmented with advanced TypeScript tooling for enhanced functionality.
Supported Databases and Runtimes
| Node | Deno | Bun | Cloudflare | Web | |
|---|---|---|---|---|---|
| Postgres | ✅ | ✅ | ✅ | ✅ | |
| PGlite | ✅ | ✅ | ✅ | ✅ | ✅ |
| MS SQL | ✅ | ✅ | |||
| MySQL | ✅ | ✅ | ✅ | ||
| MariaDB | ✅ | ✅ | ✅ | ||
| Oracle | ✅ | ✅ | ✅ | ||
| SAP ASE | ✅ | ||||
| SQLite | ✅ | ✅ | ✅ | ||
| Cloudflare D1 | ✅ |
Sponsorship ♡
If you value the hard work behind Orange and wish to see it evolve further, consider sponsoring. Your support fuels the journey of refining and expanding this tool for our developer community.
MCP (Model Context Protocol)
Orange ORM is available as an MCP resource on Context7. Use it with AI-powered tools like GitHub Copilot, Cursor, or Claude to get up-to-date documentation and code examples directly in your IDE.
👉 https://context7.com/alfateam/orange-orm