# Drizzle ORM

## Docs

- [Custom Types](https://mintlify.wiki/drizzle-team/drizzle-orm/advanced/custom-types.md): Extend Drizzle with custom column types for domain-specific data handling
- [Performance Optimization](https://mintlify.wiki/drizzle-team/drizzle-orm/advanced/performance.md): Best practices and techniques for optimizing Drizzle ORM queries and application performance
- [Prepared Statements](https://mintlify.wiki/drizzle-team/drizzle-orm/advanced/prepared-statements.md): Optimize query performance and security with prepared statements and parameter placeholders
- [Relational Queries](https://mintlify.wiki/drizzle-team/drizzle-orm/advanced/relational-queries.md): Master Drizzle's powerful relational query API for type-safe joins and nested data fetching
- [SQL Expressions](https://mintlify.wiki/drizzle-team/drizzle-orm/advanced/sql-expressions.md): Build dynamic SQL queries with Drizzle's powerful sql template tag and expression builders
- [Migrations API](https://mintlify.wiki/drizzle-team/drizzle-orm/api/core/migrations.md): Complete API reference for running database migrations in Drizzle ORM.
- [Relations API](https://mintlify.wiki/drizzle-team/drizzle-orm/api/core/relations.md): Complete API reference for defining and querying table relations in Drizzle ORM.
- [sql Template Tag](https://mintlify.wiki/drizzle-team/drizzle-orm/api/core/sql.md): Complete API reference for Drizzle ORM's sql template tag for building raw SQL queries with type safety.
- [Transactions API](https://mintlify.wiki/drizzle-team/drizzle-orm/api/core/transactions.md): Complete API reference for database transactions in Drizzle ORM across PostgreSQL, MySQL, and SQLite.
- [CLI Commands](https://mintlify.wiki/drizzle-team/drizzle-orm/api/kit/commands.md): Complete reference for all Drizzle Kit CLI commands including generate, migrate, push, pull, studio, and more.
- [Configuration](https://mintlify.wiki/drizzle-team/drizzle-orm/api/kit/configuration.md): Complete reference for drizzle.config.ts configuration options including database credentials, migrations, and advanced settings.
- [Migrations](https://mintlify.wiki/drizzle-team/drizzle-orm/api/kit/migrations.md): Complete guide to Drizzle Kit migrations including file format, programmatic API, and migration management.
- [MySQL Columns](https://mintlify.wiki/drizzle-team/drizzle-orm/api/mysql/columns.md): Complete API reference for all MySQL column types in Drizzle ORM
- [MySQL Database](https://mintlify.wiki/drizzle-team/drizzle-orm/api/mysql/database.md): API reference for MySQL database connection and query methods in Drizzle ORM
- [MySQL Query Builders](https://mintlify.wiki/drizzle-team/drizzle-orm/api/mysql/query-builders.md): API reference for MySQL query builders in Drizzle ORM - select, insert, update, delete
- [MySQL Table](https://mintlify.wiki/drizzle-team/drizzle-orm/api/mysql/table.md): API reference for defining MySQL tables in Drizzle ORM
- [MySQL Utilities](https://mintlify.wiki/drizzle-team/drizzle-orm/api/mysql/utilities.md): API reference for MySQL utility functions and helpers in Drizzle ORM
- [PostgreSQL Column Types](https://mintlify.wiki/drizzle-team/drizzle-orm/api/postgresql/columns.md): Complete reference for all PostgreSQL column types in Drizzle ORM
- [PostgreSQL Database API](https://mintlify.wiki/drizzle-team/drizzle-orm/api/postgresql/database.md): Complete API reference for the Drizzle PostgreSQL database client
- [PostgreSQL Query Builders](https://mintlify.wiki/drizzle-team/drizzle-orm/api/postgresql/query-builders.md): API reference for PostgreSQL-specific query builders and methods
- [PostgreSQL Table Definition](https://mintlify.wiki/drizzle-team/drizzle-orm/api/postgresql/table.md): API reference for defining PostgreSQL tables and schemas
- [PostgreSQL Utilities](https://mintlify.wiki/drizzle-team/drizzle-orm/api/postgresql/utilities.md): Utility functions and helpers for PostgreSQL schema and query operations
- [SQLite Columns](https://mintlify.wiki/drizzle-team/drizzle-orm/api/sqlite/columns.md): Column types and builders for SQLite tables
- [SQLite Database](https://mintlify.wiki/drizzle-team/drizzle-orm/api/sqlite/database.md): Core SQLite database API for Drizzle ORM
- [SQLite Query Builders](https://mintlify.wiki/drizzle-team/drizzle-orm/api/sqlite/query-builders.md): Query builder APIs for SELECT, INSERT, UPDATE, and DELETE operations
- [SQLite Table](https://mintlify.wiki/drizzle-team/drizzle-orm/api/sqlite/table.md): Define SQLite tables with sqliteTable() and configure schema structure
- [SQLite Utilities](https://mintlify.wiki/drizzle-team/drizzle-orm/api/sqlite/utilities.md): Utility functions and helpers for SQLite schema and queries
- [Database Connection](https://mintlify.wiki/drizzle-team/drizzle-orm/core/database-connection.md): Connect Drizzle ORM to your database with type-safe configuration and driver support
- [Migrations](https://mintlify.wiki/drizzle-team/drizzle-orm/core/migrations.md): Manage database schema changes safely with Drizzle ORM's migration system
- [Queries](https://mintlify.wiki/drizzle-team/drizzle-orm/core/queries.md): Perform type-safe database queries with Drizzle ORM's fluent API
- [Relations](https://mintlify.wiki/drizzle-team/drizzle-orm/core/relations.md): Define and query relationships between tables with Drizzle ORM's relational query API
- [Schema Declaration](https://mintlify.wiki/drizzle-team/drizzle-orm/core/schema-declaration.md): Learn how to define your database schema using Drizzle ORM's type-safe schema builders
- [Transactions](https://mintlify.wiki/drizzle-team/drizzle-orm/core/transactions.md): Execute atomic database operations with Drizzle ORM's transaction API
- [MySQL Drivers](https://mintlify.wiki/drizzle-team/drizzle-orm/drivers/mysql.md): Complete guide to MySQL and MariaDB database drivers in Drizzle ORM
- [Database Drivers](https://mintlify.wiki/drizzle-team/drizzle-orm/drivers/overview.md): Overview of database drivers and connection options in Drizzle ORM
- [PostgreSQL Drivers](https://mintlify.wiki/drizzle-team/drizzle-orm/drivers/postgresql.md): Complete guide to PostgreSQL database drivers in Drizzle ORM
- [SQLite Drivers](https://mintlify.wiki/drizzle-team/drizzle-orm/drivers/sqlite.md): Complete guide to SQLite database drivers in Drizzle ORM
- [Drizzle Kit](https://mintlify.wiki/drizzle-team/drizzle-orm/ecosystem/drizzle-kit.md): CLI tool for database migrations, schema introspection, and development workflow with Drizzle ORM
- [Drizzle Seed](https://mintlify.wiki/drizzle-team/drizzle-orm/ecosystem/drizzle-seed.md): Generate deterministic, realistic test data for your database with type-safe generators
- [Drizzle Studio](https://mintlify.wiki/drizzle-team/drizzle-orm/ecosystem/drizzle-studio.md): Visual database browser and editor for exploring and managing your database with Drizzle ORM
- [Schema Validation](https://mintlify.wiki/drizzle-team/drizzle-orm/ecosystem/schema-validation.md): Generate runtime validation schemas from Drizzle ORM with Zod, Valibot, TypeBox, and ArkType
- [Best Practices](https://mintlify.wiki/drizzle-team/drizzle-orm/guides/best-practices.md): Production-ready patterns for schema design, query optimization, and type safety with Drizzle ORM
- [Edge Runtime Compatibility](https://mintlify.wiki/drizzle-team/drizzle-orm/guides/edge-runtime.md): Deploy Drizzle ORM to edge networks for global low-latency database access
- [Migrating from Prisma](https://mintlify.wiki/drizzle-team/drizzle-orm/guides/prisma-migration.md): Complete guide to migrating your existing Prisma project to Drizzle ORM
- [Serverless Databases](https://mintlify.wiki/drizzle-team/drizzle-orm/guides/serverless.md): Use Drizzle ORM with serverless database platforms for scalable, edge-ready applications
- [Installation](https://mintlify.wiki/drizzle-team/drizzle-orm/installation.md): Install Drizzle ORM and database drivers for your project
- [Introduction to Drizzle ORM](https://mintlify.wiki/drizzle-team/drizzle-orm/introduction.md): Headless TypeScript ORM for building type-safe, performant database applications
- [Aggregations](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/aggregations.md): Perform aggregate operations in Drizzle ORM including count, sum, avg, min, max, and group by with type-safe aggregate functions.
- [Delete Queries](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/delete.md): Delete data from your database using Drizzle ORM's type-safe delete query builder with filtering and returning capabilities.
- [Insert Queries](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/insert.md): Insert data into your database using Drizzle ORM's type-safe insert query builder with support for single and bulk inserts, conflict handling, and returning values.
- [Joins](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/joins.md): Join tables together using Drizzle ORM's type-safe join operations including left, right, inner, full, and cross joins.
- [Select Queries](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/select.md): Learn how to query data with Drizzle ORM's type-safe select query builder, including filtering, ordering, limiting, and advanced select operations.
- [Subqueries](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/subqueries.md): Use subqueries in Drizzle ORM for complex nested queries, correlated subqueries, and Common Table Expressions (CTEs) with full type safety.
- [Update Queries](https://mintlify.wiki/drizzle-team/drizzle-orm/queries/update.md): Update existing data in your database using Drizzle ORM's type-safe update query builder with filtering, joins, and returning capabilities.
- [Quickstart Guide](https://mintlify.wiki/drizzle-team/drizzle-orm/quickstart.md): Build your first type-safe database application with Drizzle ORM in minutes
- [Columns](https://mintlify.wiki/drizzle-team/drizzle-orm/schema/columns.md): Define type-safe columns with Drizzle ORM for PostgreSQL, MySQL, and SQLite databases.
- [Constraints](https://mintlify.wiki/drizzle-team/drizzle-orm/schema/constraints.md): Define primary keys, foreign keys, unique constraints, and check constraints in Drizzle ORM.
- [Indexes](https://mintlify.wiki/drizzle-team/drizzle-orm/schema/indexes.md): Create and optimize database indexes with Drizzle ORM for PostgreSQL, MySQL, and SQLite.
- [Tables](https://mintlify.wiki/drizzle-team/drizzle-orm/schema/tables.md): Define tables in Drizzle ORM with type-safe schemas for PostgreSQL, MySQL, and SQLite.
- [Views](https://mintlify.wiki/drizzle-team/drizzle-orm/schema/views.md): Create database views and materialized views with Drizzle ORM for simplified queries and performance.

## OpenAPI Specs

- [openapi](https://mintlify.wiki/drizzle-team/drizzle-orm/api-reference/openapi.json)