# TypeScript-First SQL ORMs

> Search results for `TypeScript-first ORM for SQL databases` on awesome-repositories.com. 93 total matches; showing the first 50.

Explore on the web: https://awesome-repositories.com/q/typescript-first-orm-for-sql-databases

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [this search on awesome-repositories.com](https://awesome-repositories.com/q/typescript-first-orm-for-sql-databases).**

## Results

- [prisma/prisma](https://awesome-repositories.com/repository/prisma-prisma.md) (46,366 ⭐) — Prisma is a database toolkit that provides a unified access layer for interacting with relational and document databases. It centers on a declarative schema modeling approach, where developers define their data structures in a human-readable language. This schema serves as the single source of truth, from which the toolkit automatically generates type-safe database clients that provide compile-time validation and editor autocomplete for all data operations.

The project distinguishes itself through a high-performance, Rust-based query engine that handles query planning and connection pooling o
- [drizzle-team/drizzle-orm](https://awesome-repositories.com/repository/drizzle-team-drizzle-orm.md) (34,835 ⭐) — Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.
- [doctrine/orm](https://awesome-repositories.com/repository/doctrine-orm.md) (10,172 ⭐) — Doctrine ORM is a PHP object-relational mapper that connects application objects to relational database tables. It uses the data mapper and identity map patterns to decouple the in-memory object model from the database schema, allowing developers to manage data persistence without writing manual SQL.

The project features a dedicated object-oriented query language and programmatic builder for retrieving data based on entities rather than tables. It implements a unit-of-work system to track object changes during a request and synchronize them via atomic transactions.

The capability surface inc
- [electric-sql/pglite](https://awesome-repositories.com/repository/electric-sql-pglite.md) (14,707 ⭐) — Pglite is a client-side relational database engine that runs a full-featured PostgreSQL instance directly within browser and Node.js environments. By leveraging WebAssembly, it provides a persistent SQL storage solution that enables complex data management and querying without requiring an external database server.

The project distinguishes itself through a reactive SQL data layer that automatically synchronizes user interface components with live query results. It manages database operations using worker threads to prevent main-thread blocking and coordinates access across multiple browser t
- [hibernate/hibernate-orm](https://awesome-repositories.com/repository/hibernate-hibernate-orm.md) (6,447 ⭐) — Hibernate ORM is a Java object-relational mapper and a full implementation of the Jakarta Persistence API. It serves as a SQL database abstraction layer that translates Java object models into relational database schemas to manage data persistence and lifecycles.

The framework distinguishes itself with a multi-tenant data isolation framework for separating customer data within a single database instance. It also features a database schema generator that automatically produces and updates relational structures based on entity mappings.

The system covers broad capability areas including transa
- [kotlin-orm/ktorm](https://awesome-repositories.com/repository/kotlin-orm-ktorm.md) (2,336 ⭐) — Ktorm is a lightweight object-relational mapping framework for Kotlin that provides a type-safe SQL domain-specific language and functional sequence APIs for database interaction. It enables developers to define database schemas and map relational tables to interface-based objects, ensuring that data persistence and retrieval are handled through strongly-typed expressions.

The framework distinguishes itself by utilizing a functional, collection-style approach to query construction, allowing developers to chain operations like filtering, sorting, and aggregation using idiomatic language patter
- [lerocha/chinook-database](https://awesome-repositories.com/repository/lerocha-chinook-database.md) (2,544 ⭐) — This project is a relational SQL sample database and synthetic testing dataset. It provides a standardized data model of a fictional digital media store, encompassing business entities such as artists, albums, tracks, customers, and invoices.

The dataset is designed as a cross-dialect SQL collection, using compatible scripts to ensure consistent data seeding and environment parity across different database server engines. It combines imported metadata with fictitious personal details to create realistic records for software prototyping and demonstrations.

The project covers capabilities for
- [ebean-orm/ebean](https://awesome-repositories.com/repository/ebean-orm-ebean.md) (1,523 ⭐) — Ebean is a Java object-relational mapping framework designed to simplify database persistence through automated query generation, schema migration, and transaction management. It uses metadata-driven mapping and bytecode enhancement to bridge the gap between application objects and relational database tables, providing a persistent layer that handles complex data interactions while maintaining consistency across unit-of-work boundaries.

The framework distinguishes itself through its focus on developer productivity and performance optimization. It provides type-safe query builders that generat
- [dyazincahya/kbbi-sql-database](https://awesome-repositories.com/repository/dyazincahya-kbbi-sql-database.md) (45 ⭐) — Kamus Besar Bahasa Indonesia (KBBI) SQL Database, total data ``115.978`` kata.
- [opencode-ai/opencode](https://awesome-repositories.com/repository/opencode-ai-opencode.md) (11,006 ⭐) — OpenCode is a terminal-based development agent that automates software engineering tasks by integrating artificial intelligence directly into the command-line environment. It functions as an autonomous workflow orchestrator, capable of executing file operations, running shell commands, and applying code patches to complete complex development tasks without manual intervention.

The tool distinguishes itself through its ability to index local codebases into vector embeddings, enabling semantic search and natural language queries across project files. It maintains session context through a local
- [stephenafamo/bob](https://awesome-repositories.com/repository/stephenafamo-bob.md) (1,739 ⭐) — This project is a database toolkit for Go that provides schema-to-object mapping, fluent query construction, and automated code generation. It functions as a framework for type-safe database access, enabling developers to interact with relational databases by generating models and interfaces directly from existing database schemas.

The toolkit distinguishes itself through a workflow that parses hand-written SQL files to generate type-safe functions, allowing for the integration of custom SQL while maintaining consistent result mapping. It supports modular customization through a plugin-based
- [mikro-orm/mikro-orm](https://awesome-repositories.com/repository/mikro-orm-mikro-orm.md) (9,085 ⭐) — Mikro-ORM is a TypeScript-based object-relational mapping system that provides a unified persistence layer for Node.js applications. It translates TypeScript entities into relational or document-based database schemas, supporting a variety of engines including PostgreSQL, MySQL, MariaDB, MS SQL Server, SQLite, and MongoDB.

The project implements the data mapper pattern to decouple in-memory domain models from the database persistence layer. It utilizes a unit of work pattern to track entity changes in memory and commit them in a single coordinated database transaction.

The library covers com
- [umami-software/umami](https://awesome-repositories.com/repository/umami-software-umami.md) (37,285 ⭐) — Umami is a self-hosted, privacy-focused web analytics platform designed to provide full control over infrastructure and user data. It captures website traffic and visitor behavior through anonymous tracking methods that avoid cookies, browser fingerprinting, and the storage of personally identifiable information.

The platform distinguishes itself through a comprehensive suite of behavioral analysis tools, including session replays, heatmaps, and cohort-based retention reporting. It features a multi-tenant architecture that allows teams to manage multiple websites within a single, collaborativ
- [prismagraphql/prisma](https://awesome-repositories.com/repository/prismagraphql-prisma.md) (16,393 ⭐) — Prisma is a type-safe database object-relational mapper that uses a declarative schema to map data models to relational and document databases. It provides a unified toolkit for data access, combining a database driver with tools for schema management and record manipulation.

The project features a multi-database driver that standardizes interactions across PostgreSQL, MySQL, and MongoDB. It includes a system for tracking and applying structural schema migrations across different environments and a graphical user interface for browsing and editing database records.

The system ensures data in
- [encode/orm](https://awesome-repositories.com/repository/encode-orm.md) (1,863 ⭐) — An async ORM. 🗃
- [cycle/orm](https://awesome-repositories.com/repository/cycle-orm.md) (1,328 ⭐) — PHP DataMapper, ORM
- [memorilabs/memori](https://awesome-repositories.com/repository/memorilabs-memori.md) (15,358 ⭐) — Memori is an AI agent memory middleware platform designed to provide persistent, context-aware recall for language models. It functions as a non-intrusive layer that intercepts outbound model requests to automatically capture interaction history and execution traces, ensuring that agents maintain continuity across sessions without requiring modifications to existing application logic.

The platform distinguishes itself through a dual-model storage architecture that maintains information as both structured relational primitives for precise fact retrieval and rolling narrative summaries for situ
- [a16z-infra/ai-town](https://awesome-repositories.com/repository/a16z-infra-ai-town.md) (9,285 ⭐) — AI Town is a TypeScript-based simulation engine used to create virtual environments where autonomous characters interact and socialize. It functions as a framework for orchestrating multiple AI agents within a persistent digital world, utilizing language models and a game engine to drive character behavior and social interactions.

The project differentiates itself through a dedicated agent sandbox and a vector database agent store, which allow for the management of agent memories and world state. It integrates generative AI for background music and provides tools for simulation world design,
- [fastapi/fastapi](https://awesome-repositories.com/repository/fastapi-fastapi.md) (99,260 ⭐) — FastAPI is a web framework for building APIs with Python. It leverages standard language type hints to provide automatic data validation, request parsing, and interactive API documentation generation. The framework supports asynchronous request handling and manages execution contexts to prevent blocking the main event loop.

The project includes a dependency injection system that allows for the resolution and injection of reusable components into request handlers. This system supports request-scoped caching, lifecycle management, and integration with security mechanisms like OAuth2 and JSON We
- [pubkey/rxdb](https://awesome-repositories.com/repository/pubkey-rxdb.md) (23,048 ⭐) — This project is a reactive, offline-first NoSQL database engine designed for JavaScript applications. It provides a robust framework for managing application state by synchronizing data across browsers, mobile devices, and server-side runtimes. By treating local storage as the primary source of truth, it enables applications to remain functional without network connectivity, automatically reconciling changes with remote backends once a connection is restored.

The database distinguishes itself through a modular architecture that supports cross-environment synchronization and high-performance d
- [kyleconroy/sqlc](https://awesome-repositories.com/repository/kyleconroy-sqlc.md) (17,886 ⭐) — sqlc is a SQL compiler and code generator that creates type-safe database client code from raw SQL queries. It transforms SQL statements into typed definitions and functions, eliminating the need for manual row mapping between database results and application structures.

The tool ensures compile-time safety by validating SQL queries against the database schema before the application is run. This workflow integrates the database schema directly into the application code, deriving types from the underlying SQL definitions to prevent runtime errors.

The system utilizes AST-based query analysis
- [sql-js/sql.js](https://awesome-repositories.com/repository/sql-js-sql-js.md) (13,632 ⭐) — sql.js is a serverless, in-memory SQL database engine that ports SQLite to WebAssembly for use within a web browser. It provides a JavaScript interface to initialize relational databases, execute SQL queries, and manage structured data without requiring a backend server.

The project enables the import and export of database states using typed arrays, allowing in-memory data to be persisted as files. It supports high-precision integer retrieval via BigInt and utilizes prepared statements to increase execution speed and security.

The engine includes capabilities for client-side data management
- [tortoise/tortoise-orm](https://awesome-repositories.com/repository/tortoise-tortoise-orm.md) (5,582 ⭐) — Tortoise ORM is an asynchronous object-relational mapper for Python that mirrors Django's model and queryset API while running on asyncio. It defines database tables as Python classes with typed fields and supports foreign key, many-to-many, and one-to-one relations, providing a chainable query API for filtering, annotating, grouping, and prefetching related objects without blocking the event loop.

The ORM includes a built-in migration engine that detects model changes, generates migration files, and applies or reverts schema changes through a command-line tool. It connects to PostgreSQL, MyS
- [techschool/simplebank](https://awesome-repositories.com/repository/techschool-simplebank.md) (6,495 ⭐) — Simplebank is a financial services backend application built with Go that manages bank accounts and transfers. It utilizes a dual-protocol interface, providing both gRPC and REST APIs via Protocol Buffers to support different client communication requirements.

The system implements a PostgreSQL data layer with versioned schema migrations and type-safe query generation. It handles financial operations through atomic fund transfers and balance change tracking to maintain consistent audit trails.

The architecture includes an asynchronous task worker system using a message queue to offload long-
- [launchbadge/sqlx](https://awesome-repositories.com/repository/launchbadge-sqlx.md) (16,630 ⭐) — This toolkit provides an asynchronous interface for interacting with relational databases, offering a unified driver-agnostic layer for managing connection pools and executing transactions. It is designed to integrate with asynchronous runtimes, enabling non-blocking database operations while maintaining secure, encrypted communication between the application and the database server.

The project distinguishes itself through its compile-time validation capabilities, which use procedural macros to inspect SQL syntax and parameter types against a live database schema during the build process. Th
- [encoredev/encore](https://awesome-repositories.com/repository/encoredev-encore.md) (12,049 ⭐) — Encore is a distributed systems framework designed to unify backend development, infrastructure provisioning, and observability. It functions as an infrastructure-as-code platform that allows developers to define cloud resources, databases, and messaging topics directly within their application code. By analyzing these declarations at compile-time, the system automatically manages the deployment of cloud resources and security policies, ensuring parity between local development and production environments.

The platform distinguishes itself through its integrated development experience, which
- [embarcadero/dev-cpp](https://awesome-repositories.com/repository/embarcadero-dev-cpp.md) (2,882 ⭐) — Dev-Cpp is a comprehensive development suite that serves as a C++ integrated development environment, a cross-platform application builder, and a visual UI designer. It provides a toolchain for writing, compiling, and debugging native C++ applications on Windows, while offering a framework to create native binaries for desktop, mobile, and IoT devices from a single codebase.

The project distinguishes itself by integrating an embedded SQL database engine and a REST API development platform directly into the workflow. It includes an AI-assisted coding tool that leverages large language models t
- [sqlc-dev/sqlc](https://awesome-repositories.com/repository/sqlc-dev-sqlc.md) (17,882 ⭐) — sqlc is a code generation tool that compiles raw SQL queries into type-safe application code. By analyzing SQL statements against database schema definitions during the build process, it eliminates the need for manual data mapping and prevents runtime type errors.

The project functions as a schema-aware generator that translates database column types into native language primitives. It distinguishes itself through a modular, plugin-based architecture that allows for the extension of the generation pipeline to support diverse programming languages and custom frameworks beyond its default capab
- [seaql/sea-orm](https://awesome-repositories.com/repository/seaql-sea-orm.md) (9,410 ⭐) — Sea-ORM is an asynchronous SQL object-relational mapper and database toolkit for mapping relational tables to strongly typed objects. It provides a relational database mapper for performing CRUD operations across MySQL, PostgreSQL, and SQLite, and includes a programmatic dynamic query builder for constructing complex SQL statements.

The project distinguishes itself by providing a GraphQL schema generator that transforms database entities into typed schemas with built-in pagination and filters. It also features a dedicated database migration tool for defining and applying versioned schema chan
- [ljlm0402/typescript-express-starter](https://awesome-repositories.com/repository/ljlm0402-typescript-express-starter.md) (2,882 ⭐) — This project is a production-ready foundation and boilerplate for building backend APIs using TypeScript and Express. It functions as an interactive scaffolder and starter kit that generates structured project directories, providing a base for REST API development.

The toolkit includes a command-line interface for project generation, which uses templates and naming conventions to establish folder organization. It provides curated configurations for the development toolchain, including linters, bundlers, and testing frameworks.

The project covers database and ORM integration through specific
- [laravel-doctrine/orm](https://awesome-repositories.com/repository/laravel-doctrine-orm.md) (838 ⭐) — An integration library for Laravel and Doctrine ORM
- [terrakok/kmp-awesome](https://awesome-repositories.com/repository/terrakok-kmp-awesome.md) (5,785 ⭐) — KMP-Awesome is a curated directory and resource index for the Kotlin Multiplatform ecosystem. It serves as a centralized hub for developers to discover libraries, frameworks, and tools designed to streamline the creation of shared codebases for mobile, desktop, and web applications.

The project distinguishes itself by organizing a comprehensive collection of solutions that address the core challenges of cross-platform development. It highlights resources for implementing shared business logic, declarative user interface components, and type-safe data persistence layers. By providing a structu
- [danieleteti/delphi-orm](https://awesome-repositories.com/repository/danieleteti-delphi-orm.md) (175 ⭐) — Delphi ORM (DORM for short) is a powerful ORM for Delphi. It is quite robust and tested because used since 2010 in production for many business critical systems.
- [dlt-hub/dlt](https://awesome-repositories.com/repository/dlt-hub-dlt.md) (5,472 ⭐) — dlt is a Python data ingestion tool and ETL pipeline framework designed to fetch data from diverse sources and persist it into structured destinations. It functions as a schema inference engine that automatically detects data types and flattens nested JSON structures into relational tables, moving data from sources to lakehouses, warehouses, or vector databases.

The project distinguishes itself through AI-powered pipeline generation, using large language models to scaffold extraction code and connectors for REST APIs. It also supports multimodal vector storage and specialized population of ve
- [kysely-org/kysely](https://awesome-repositories.com/repository/kysely-org-kysely.md) (13,969 ⭐) — Kysely is a TypeScript SQL query builder that provides a type-safe interface for constructing and executing database queries. It functions as a database layer that ensures schema compliance and prevents runtime errors by using a fluent interface and a programmable way to build complex SQL statements.

The project features a type-safe database layer capable of inferring return types and aliases from SQL selections and joins. It also includes a SQL migration manager to track and apply schema changes across different environments to keep database versions synchronized.

The toolkit covers relatio
- [auraphp/aura.sql](https://awesome-repositories.com/repository/auraphp-aura-sql.md) (564 ⭐) — SQL database access through PDO.
- [supabase/supabase-js](https://awesome-repositories.com/repository/supabase-supabase-js.md) (4,483 ⭐) — supabase-js is a comprehensive client library designed to integrate frontend applications with a hosted backend-as-a-service. It provides a unified interface for interacting with a PostgreSQL database, identity management systems, cloud object storage, and real-time data synchronization.

The library features an isomorphic client design that operates across both browser and server environments. It distinguishes itself through a type-safe approach, utilizing TypeScript to map database schemas directly to client-side definitions, and employs a PostgREST-based API to translate JavaScript calls in
- [electric-sql/electric](https://awesome-repositories.com/repository/electric-sql-electric.md) (9,909 ⭐) — Electric is a Postgres data synchronization engine and replication proxy designed to enable local-first software. It replicates data from Postgres databases to client-side stores in real time using logical replication, allowing applications to maintain a local embedded database for offline access and low-latency updates.

The system distinguishes itself by using shapes to filter and authorize specific subsets of database rows and columns before streaming them to clients or edge workers. It further supports multi-user collaboration by integrating a conflict-free replicated data type framework t
- [geldata/gel](https://awesome-repositories.com/repository/geldata-gel.md) (14,065 ⭐) — Gel is an object-relational database system that models data as a graph of interconnected objects. By utilizing a strongly typed schema, it enables complex relational queries and polymorphic data structures without the need for traditional join tables. The system integrates native vector storage and similarity search operators, allowing it to function as both a relational and a vector database for semantic data retrieval.

The platform distinguishes itself through a comprehensive suite of developer-centric automation tools. It features a declarative migration system that tracks and versions sc
- [tommikaikkonen/redux-orm](https://awesome-repositories.com/repository/tommikaikkonen-redux-orm.md) (2,932 ⭐) — ``bash npm install redux-orm --save ``
- [rayhollister/database-users-for-yourls](https://awesome-repositories.com/repository/rayhollister-database-users-for-yourls.md) (4 ⭐) — Database Users replaces the static credential array in user/config.php with a database-backed user table and a lightweight administration panel. Activate it to keep logins inside YOURLS, grant a password self-service form, and stay compatible with existing hashing schemes.
- [ixartz/next-js-boilerplate](https://awesome-repositories.com/repository/ixartz-next-js-boilerplate.md) (12,982 ⭐) — This project is a production-ready starter template for building web applications with the React framework. It provides a structured environment that enforces type safety and consistent coding standards across the entire application stack using TypeScript.

The boilerplate distinguishes itself by integrating pre-configured modules for authentication, database management, and internationalization. It includes built-in support for managing user sessions, performing type-safe database operations, and localizing interface content into multiple languages to support a global user base.

The project
- [grafana/xk6-sql](https://awesome-repositories.com/repository/grafana-xk6-sql.md) (190 ⭐) — Use SQL databases from k6 tests.
- [crazyguitar/pysheeet](https://awesome-repositories.com/repository/crazyguitar-pysheeet.md) (8,150 ⭐) — pysheeet is a technical reference library providing a curated collection of code snippets and implementation patterns for advanced Python development, system integration, and high-performance computing. It serves as a comprehensive guide for implementing low-level network programming, native C extensions, and asynchronous and concurrent programming.

The project provides specialized frameworks for the development and deployment of large language models, including tools for distributed GPU inference and high-performance serving. It also includes detailed patterns for high-performance computing
- [prisma/prisma-client-js](https://awesome-repositories.com/repository/prisma-prisma-client-js.md) (1,465 ⭐) — Prisma Client is a database client for Node.js and TypeScript applications that provides a type-safe interface for interacting with relational databases. It functions as an object-relational mapper that translates declarative schema definitions into strongly typed query interfaces, ensuring that database operations align with the underlying data structure.

The library distinguishes itself by generating type definitions directly from a schema model, which enables static analysis and IDE autocompletion during development. By abstracting database interactions into a unified query language, it st
- [android/kotlin-multiplatform-samples](https://awesome-repositories.com/repository/android-kotlin-multiplatform-samples.md) (1,290 ⭐) — This repository provides a collection of reference implementations for building mobile applications using the Kotlin Multiplatform framework. It serves as a practical guide for centralizing core application logic, data handling, and business rules into a single shared codebase while maintaining the ability to build native user interfaces for Android and iOS.

The project demonstrates architectural patterns for managing state, persistence, and network synchronization across diverse mobile operating systems. By utilizing common source sets and platform-specific native interop, it enables develop
- [avelino/awesome-go](https://awesome-repositories.com/repository/avelino-awesome-go.md) (175,576 ⭐) — This project serves as a comprehensive language ecosystem index, functioning as a centralized, community-curated directory for the Go programming language. It organizes a vast landscape of software components, libraries, and development tools into a structured, navigable hierarchy, enabling developers to efficiently discover resources tailored to specific functional domains.

The repository distinguishes itself through a decentralized contribution model, where community-driven updates ensure the index remains current with the rapidly evolving software landscape. Beyond simple resource listing,
- [shadcn-ui/taxonomy](https://awesome-repositories.com/repository/shadcn-ui-taxonomy.md) (19,248 ⭐) — Taxonomy is a full-stack application template and reference implementation built with the Next.js app router. It serves as a comprehensive starter for developing web applications using server components and modern React patterns.

The project integrates a variety of specialized systems, including an identity management workflow for OAuth and session handling, and a billing system for managing recurring subscriptions and payment events. It also features a content pipeline that transforms Markdown and JSX files into type-safe data collections for rendering blogs and documentation.

The architect
- [encode/databases](https://awesome-repositories.com/repository/encode-databases.md) (4,002 ⭐) — Async database support for Python. 🗄
- [jackc/pgx](https://awesome-repositories.com/repository/jackc-pgx.md) (13,428 ⭐) — This project is a database driver and interface for the Go programming language, specifically designed for PostgreSQL. It provides a low-level library for executing SQL queries, managing transactions, and handling data persistence within Go applications.

The driver distinguishes itself by implementing the native PostgreSQL binary wire protocol, which minimizes communication overhead and maximizes data transfer efficiency. It includes advanced connection pooling to maintain persistent database sessions and supports prepared statement caching to accelerate the execution of frequently repeated o