# Kysely

## Docs

- [AggregateFunctionBuilder](https://mintlify.wiki/kysely-org/kysely/api/aggregate-function-builder.md): Builder for SQL aggregate functions with filtering, ordering, and window function support
- [AlterTableBuilder](https://mintlify.wiki/kysely-org/kysely/api/alter-table-builder.md): Builder for altering table definitions in Kysely
- [CaseBuilder](https://mintlify.wiki/kysely-org/kysely/api/case-builder.md): Builder for SQL CASE expressions and statements in Kysely queries
- [ColumnDefinitionBuilder](https://mintlify.wiki/kysely-org/kysely/api/column-definition-builder.md): Builder for defining column properties in Kysely table schemas
- [CreateTableBuilder](https://mintlify.wiki/kysely-org/kysely/api/create-table-builder.md): Builder for creating table definitions in Kysely
- [DeleteQueryBuilder](https://mintlify.wiki/kysely-org/kysely/api/delete-query-builder.md): Build and execute DELETE queries
- [MssqlDialect](https://mintlify.wiki/kysely-org/kysely/api/dialects/mssql.md): MS SQL Server dialect using the tedious library
- [MysqlDialect](https://mintlify.wiki/kysely-org/kysely/api/dialects/mysql.md): MySQL dialect using the mysql2 library
- [Dialect Interface](https://mintlify.wiki/kysely-org/kysely/api/dialects/overview.md): The glue between Kysely and the underlying database engine
- [PostgresDialect](https://mintlify.wiki/kysely-org/kysely/api/dialects/postgresql.md): PostgreSQL dialect using the pg library
- [SqliteDialect](https://mintlify.wiki/kysely-org/kysely/api/dialects/sqlite.md): SQLite dialect using the better-sqlite3 library
- [ExpressionBuilder](https://mintlify.wiki/kysely-org/kysely/api/expression-builder.md): A type-safe expression builder for creating SQL expressions in Kysely queries
- [InsertQueryBuilder](https://mintlify.wiki/kysely-org/kysely/api/insert-query-builder.md): Build and execute INSERT queries
- [JSONPathBuilder](https://mintlify.wiki/kysely-org/kysely/api/json-path-builder.md): Type-safe builder for traversing JSON columns and creating JSON path expressions
- [Kysely](https://mintlify.wiki/kysely-org/kysely/api/kysely.md): Main Kysely class for database operations
- [MigrationProvider](https://mintlify.wiki/kysely-org/kysely/api/migration-provider.md): Interfaces and classes for providing migrations to the Kysely Migrator.
- [Migrator](https://mintlify.wiki/kysely-org/kysely/api/migrator.md): A class for running database migrations in Kysely.
- [CamelCasePlugin](https://mintlify.wiki/kysely-org/kysely/api/plugins/camel-case.md): Converts snake_case identifiers in the database to camelCase in JavaScript
- [Creating Custom Plugins](https://mintlify.wiki/kysely-org/kysely/api/plugins/custom-plugins.md): Guide to creating custom Kysely plugins for query transformation and result processing
- [DeduplicateJoinsPlugin](https://mintlify.wiki/kysely-org/kysely/api/plugins/deduplicate-joins.md): Removes duplicate join clauses from queries automatically
- [KyselyPlugin Interface](https://mintlify.wiki/kysely-org/kysely/api/plugins/overview.md): Core interface for creating Kysely plugins that transform queries and results
- [ParseJSONResultsPlugin](https://mintlify.wiki/kysely-org/kysely/api/plugins/parse-json-results.md): Parses JSON strings in query results into JavaScript objects and arrays
- [WithSchemaPlugin](https://mintlify.wiki/kysely-org/kysely/api/plugins/with-schema.md): Automatically adds a schema prefix to all table references in queries
- [RawBuilder](https://mintlify.wiki/kysely-org/kysely/api/raw-builder.md): Create raw SQL snippets and queries with type safety in Kysely
- [SchemaModule](https://mintlify.wiki/kysely-org/kysely/api/schema.md): Provides methods for building database schema in Kysely
- [SelectQueryBuilder](https://mintlify.wiki/kysely-org/kysely/api/select-query-builder.md): Build and execute SELECT queries
- [ColumnType](https://mintlify.wiki/kysely-org/kysely/api/types/column-type.md): Specify different types for select, insert, and update operations on database columns
- [Generated & GeneratedAlways](https://mintlify.wiki/kysely-org/kysely/api/types/generated.md): Shortcuts for defining database-generated columns in Kysely
- [Insertable](https://mintlify.wiki/kysely-org/kysely/api/types/insertable.md): Extract the insert type from a table interface in Kysely
- [Selectable](https://mintlify.wiki/kysely-org/kysely/api/types/selectable.md): Extract the select type from a table interface in Kysely
- [Updateable](https://mintlify.wiki/kysely-org/kysely/api/types/updateable.md): Extract the update type from a table interface in Kysely
- [UpdateQueryBuilder](https://mintlify.wiki/kysely-org/kysely/api/update-query-builder.md): Build and execute UPDATE queries
- [Database Types](https://mintlify.wiki/kysely-org/kysely/core-concepts/database-types.md): Learn how to define type-safe database interfaces in Kysely using ColumnType, Generated, and other type utilities
- [Dialects](https://mintlify.wiki/kysely-org/kysely/core-concepts/dialects.md): Learn about Kysely's database dialect system and how to configure PostgreSQL, MySQL, SQLite, and MS SQL Server
- [Plugins](https://mintlify.wiki/kysely-org/kysely/core-concepts/plugins.md): Learn how to use and create Kysely plugins to transform queries and results
- [Query Building](https://mintlify.wiki/kysely-org/kysely/core-concepts/query-building.md): Learn how Kysely's builder pattern and method chaining enables type-safe, composable SQL queries
- [Type Safety](https://mintlify.wiki/kysely-org/kysely/core-concepts/type-safety.md): Understand how Kysely leverages TypeScript's type system to provide compile-time safety for SQL queries
- [Installation](https://mintlify.wiki/kysely-org/kysely/installation.md): Install Kysely using npm, yarn, pnpm, or bun for your TypeScript SQL projects.
- [Introduction to Kysely](https://mintlify.wiki/kysely-org/kysely/introduction.md): A type-safe and autocompletion-friendly TypeScript SQL query builder for PostgreSQL, MySQL, SQLite, and MS SQL Server.
- [Delete Queries](https://mintlify.wiki/kysely-org/kysely/operations/delete.md): Learn how to delete data from your database using Kysely's DeleteQueryBuilder with type-safe delete statements.
- [Insert Queries](https://mintlify.wiki/kysely-org/kysely/operations/insert.md): Learn how to insert data into your database using Kysely's InsertQueryBuilder with type-safe insert statements.
- [Join Operations](https://mintlify.wiki/kysely-org/kysely/operations/joins.md): Learn how to use join operations in Kysely to combine data from multiple tables with type-safe join statements.
- [Raw SQL](https://mintlify.wiki/kysely-org/kysely/operations/raw-sql.md): Learn how to use raw SQL in Kysely with the sql template tag for complex queries and database-specific features.
- [Select Queries](https://mintlify.wiki/kysely-org/kysely/operations/select.md): Learn how to use Kysely's SelectQueryBuilder to query data from your database with type-safe select statements.
- [Transactions](https://mintlify.wiki/kysely-org/kysely/operations/transactions.md): Learn how to use transactions in Kysely to ensure atomic database operations with type-safe transaction handling.
- [Update Queries](https://mintlify.wiki/kysely-org/kysely/operations/update.md): Learn how to update data in your database using Kysely's UpdateQueryBuilder with type-safe update statements.
- [Quick Start](https://mintlify.wiki/kysely-org/kysely/quickstart.md): Get started with Kysely in minutes by setting up your database schema and running your first type-safe query.
- [Conditional Select Statements](https://mintlify.wiki/kysely-org/kysely/recipes/conditional-selects.md): Learn how to select fields conditionally based on runtime conditions
- [Working with Data Types](https://mintlify.wiki/kysely-org/kysely/recipes/data-types.md): Understand TypeScript types vs runtime types and configure your database driver
- [Building Dynamic Queries](https://mintlify.wiki/kysely-org/kysely/recipes/dynamic-queries.md): Use the DynamicModule to build queries with runtime column and table names
- [Understanding Expressions](https://mintlify.wiki/kysely-org/kysely/recipes/expressions.md): Learn how to use Expression<T> and ExpressionBuilder to create complex, type-safe queries
- [Modeling and Querying Relations](https://mintlify.wiki/kysely-org/kysely/recipes/relations.md): Learn how to nest related rows in Kysely queries using JSON functions
- [Creating Reusable Helper Functions](https://mintlify.wiki/kysely-org/kysely/recipes/reusable-helpers.md): Build composable, type-safe helper functions for common SQL operations
- [Altering Tables](https://mintlify.wiki/kysely-org/kysely/schema/altering-tables.md): Modify existing tables by adding, dropping, or altering columns and constraints
- [Creating Tables](https://mintlify.wiki/kysely-org/kysely/schema/creating-tables.md): Create tables with columns, constraints, and indexes using Kysely's schema builder
- [Database Introspection](https://mintlify.wiki/kysely-org/kysely/schema/introspection.md): Inspect database metadata including tables, columns, and schemas at runtime
- [Migrations](https://mintlify.wiki/kysely-org/kysely/schema/migrations.md): Manage database schema changes over time with Kysely's migration system