# Table of contents

Database adapters and query layer for Atscript — define your models once, get type-safe CRUD for any database

## Web links

- [home](db.atscript.dev/)
- [](db.atscript.dev/_experimental-warning)
- [Adapter Overview](db.atscript.dev/adapters)
- [Annotations Reference](db.atscript.dev/adapters/annotations)
- [Creating Custom Adapters](db.atscript.dev/adapters/creating-adapters)
- [MongoDB](db.atscript.dev/adapters/mongodb)
- [MySQL](db.atscript.dev/adapters/mysql)
- [PostgreSQL](db.atscript.dev/adapters/postgresql)
- [SQLite](db.atscript.dev/adapters/sqlite)
- [Value-Help Controllers](db.atscript.dev/adapters/value-help)
- [CRUD Operations](db.atscript.dev/api/crud)
- [Defaults & Generated Values](db.atscript.dev/api/defaults)
- [Field Encryption](db.atscript.dev/api/encryption)
- [Indexes & Constraints](db.atscript.dev/api/indexes)
- [Queries & Filters](db.atscript.dev/api/queries)
- [Storage & Nested Objects](db.atscript.dev/api/storage)
- [Tables & Fields](db.atscript.dev/api/tables)
- [Transactions](db.atscript.dev/api/transactions)
- [Update & Patch](db.atscript.dev/api/update-patch)
- [Optimistic Concurrency (Row Versioning)](db.atscript.dev/api/versioning)
- [Database Layer](db.atscript.dev/guide)
- [](db.atscript.dev/guide/_experimental-warning)
- [Quick Start](db.atscript.dev/guide/quick-start)
- [Setup](db.atscript.dev/guide/setup)
- [HTTP Setup](db.atscript.dev/http)
- [Actions](db.atscript.dev/http/actions)
- [Relations & Search in URLs](db.atscript.dev/http/advanced)
- [HTTP Client](db.atscript.dev/http/client)
- [CRUD Endpoints](db.atscript.dev/http/crud)
- [Customization](db.atscript.dev/http/customization)
- [Permissions](db.atscript.dev/http/permissions)
- [URL Query Syntax](db.atscript.dev/http/query-syntax)
- [Foreign Keys](db.atscript.dev/relations)
- [Deep Operations](db.atscript.dev/relations/deep-operations)
- [Loading Relations](db.atscript.dev/relations/loading)
- [Navigation Properties](db.atscript.dev/relations/navigation)
- [Relational Patches](db.atscript.dev/relations/patches)
- [Referential Actions](db.atscript.dev/relations/referential-actions)
- [Text Search](db.atscript.dev/search)
- [Geo Search](db.atscript.dev/search/geo-search)
- [Vector Search](db.atscript.dev/search/vector-search)
- [How Schema Sync Works](db.atscript.dev/sync)
- [CI/CD Integration](db.atscript.dev/sync/ci-cd)
- [CLI](db.atscript.dev/sync/cli)
- [Configuration](db.atscript.dev/sync/configuration)
- [Programmatic API](db.atscript.dev/sync/programmatic)
- [What Gets Synced](db.atscript.dev/sync/what-gets-synced)
- [Defining Views](db.atscript.dev/views)
- [Aggregation Views](db.atscript.dev/views/aggregation-views)
- [Aggregation Annotations](db.atscript.dev/views/aggregations)
- [Querying Views](db.atscript.dev/views/querying-views)
- [View Types](db.atscript.dev/views/view-types)

## LLMs links

- [home](db.atscript.dev/index.md)
- [](db.atscript.dev/_experimental-warning.md)
- [Adapter Overview](db.atscript.dev/adapters.md)
- [Annotations Reference](db.atscript.dev/adapters/annotations.md)
- [Creating Custom Adapters](db.atscript.dev/adapters/creating-adapters.md)
- [MongoDB](db.atscript.dev/adapters/mongodb.md)
- [MySQL](db.atscript.dev/adapters/mysql.md)
- [PostgreSQL](db.atscript.dev/adapters/postgresql.md)
- [SQLite](db.atscript.dev/adapters/sqlite.md)
- [Value-Help Controllers](db.atscript.dev/adapters/value-help.md)
- [CRUD Operations](db.atscript.dev/api/crud.md)
- [Defaults & Generated Values](db.atscript.dev/api/defaults.md)
- [Field Encryption](db.atscript.dev/api/encryption.md)
- [Indexes & Constraints](db.atscript.dev/api/indexes.md)
- [Queries & Filters](db.atscript.dev/api/queries.md)
- [Storage & Nested Objects](db.atscript.dev/api/storage.md)
- [Tables & Fields](db.atscript.dev/api/tables.md)
- [Transactions](db.atscript.dev/api/transactions.md)
- [Update & Patch](db.atscript.dev/api/update-patch.md)
- [Optimistic Concurrency (Row Versioning)](db.atscript.dev/api/versioning.md)
- [Database Layer](db.atscript.dev/guide.md)
- [](db.atscript.dev/guide/_experimental-warning.md)
- [Quick Start](db.atscript.dev/guide/quick-start.md)
- [Setup](db.atscript.dev/guide/setup.md)
- [HTTP Setup](db.atscript.dev/http.md)
- [Actions](db.atscript.dev/http/actions.md)
- [Relations & Search in URLs](db.atscript.dev/http/advanced.md)
- [HTTP Client](db.atscript.dev/http/client.md)
- [CRUD Endpoints](db.atscript.dev/http/crud.md)
- [Customization](db.atscript.dev/http/customization.md)
- [Permissions](db.atscript.dev/http/permissions.md)
- [URL Query Syntax](db.atscript.dev/http/query-syntax.md)
- [Foreign Keys](db.atscript.dev/relations.md)
- [Deep Operations](db.atscript.dev/relations/deep-operations.md)
- [Loading Relations](db.atscript.dev/relations/loading.md)
- [Navigation Properties](db.atscript.dev/relations/navigation.md)
- [Relational Patches](db.atscript.dev/relations/patches.md)
- [Referential Actions](db.atscript.dev/relations/referential-actions.md)
- [Text Search](db.atscript.dev/search.md)
- [Geo Search](db.atscript.dev/search/geo-search.md)
- [Vector Search](db.atscript.dev/search/vector-search.md)
- [How Schema Sync Works](db.atscript.dev/sync.md)
- [CI/CD Integration](db.atscript.dev/sync/ci-cd.md)
- [CLI](db.atscript.dev/sync/cli.md)
- [Configuration](db.atscript.dev/sync/configuration.md)
- [Programmatic API](db.atscript.dev/sync/programmatic.md)
- [What Gets Synced](db.atscript.dev/sync/what-gets-synced.md)
- [Defining Views](db.atscript.dev/views.md)
- [Aggregation Views](db.atscript.dev/views/aggregation-views.md)
- [Aggregation Annotations](db.atscript.dev/views/aggregations.md)
- [Querying Views](db.atscript.dev/views/querying-views.md)
- [View Types](db.atscript.dev/views/view-types.md)