# Changelog

## [3.4.1](https://github.com/xylex-group/athena/compare/v3.4.0...v3.4.1) (2026-04-10)

### Features

- `pipeline_step_log` table on the logging database records `source`, `transform`, and `sink` steps for each `POST /pipelines` run (with `pipeline_run_id`, optional `pipeline_name`, timings, and details). Migration `sql/migrations/add_pipeline_step_log.sql` and `sql/provision.sql` updated.
- `GET /pipelines/templates` includes optional `source_client` and `sink_client` from YAML; successful pipeline responses include `pipeline_run_id`.

### Documentation

- Document pipeline client overrides, `dry_run`, `pipeline_run_id`, `pipeline_step_log`, API key scoping, and template fields in `openapi.yaml` and `index.yaml`. Comment `source.client` / `sink.client` in `config/pipelines.yaml`.

## [3.2.0](https://github.com/xylex-group/athena/compare/v3.1.0...v3.2.0) (2026-04-03)

### Features

- Optional Postgres `/gateway/insert` execution window: config `gateway.insert_execution_window_ms` and/or `X-Athena-Insert-Window` batch compatible inserts per client/table/column-shape, with bounded queue fallback and merge denylist (`gateway.insert_merge_deny_tables`). Prometheus counter `athena_gateway_insert_window_events_total` records flush and fallback reasons.
- **Gateway webhooks:** Postgres-backed `gateway_webhook` / `gateway_webhook_delivery` on the logging database; optional outbound HTTP after successful gateway and `rest/v1` operations; `{{...}}` URL/header/body templates with optional `{{ATHENA.schema.table.column}}` lookups; admin routes under `/admin/webhooks*`; Athena Studio **Webhooks** page.
- **Tests:** Unit coverage for webhook templating/idempotency in `src/webhooks/dispatch.rs`; optional Docker e2e `tests/gateway_webhooks_e2e.rs` behind `ATHENA_RUN_GATEWAY_WEBHOOKS_E2E=1`.
- **Schema webhooks:** After successful `/management/*` DDL (create/drop table, column add/drop/rename/alter, index create/drop, extension install), Athena dispatches the same outbound webhook pipeline with `route_key` values `schema_*` (migration `sql/migrations/add_gateway_webhook_schema_route_keys.sql` expands the DB check constraint).
- **Webhook admin API:** `GET /admin/webhooks/events` returns the full `route_key` catalog; `GET /admin/webhooks` accepts optional `client_name` to filter definitions.

### Documentation

- Document `X-Athena-Insert-Window` and insert-window semantics on `PUT /gateway/insert` in `openapi.yaml`.
- Document gateway insert window keys in `config.yaml`.
- Document `/admin/webhooks` admin routes in `openapi.yaml` (gateway webhook definitions, delivery log, and test dispatch); note gateway webhook routes in `README.md`.
- Clarify in `README.md`, `openapi.yaml`, and `index.yaml` that `/management` DDL audit tables live on the gateway logging Postgres client; update related 503 descriptions.

## [2.12.0](https://github.com/xylex-group/athena/compare/v2.11.0...v2.12.0) (2026-03-28)

### Documentation

- Sync `openapi.yaml` and `index.yaml` with `POST /query/count` (cached row count via validated COUNT SQL or structured `table_name` / `table_schema`).

## [2.9.0](https://github.com/xylex-group/athena/compare/v2.8.1...v2.9.0) (2026-03-23)

### Features

- `POST /admin/backups/jobs/{id}/cancel` stops an in-process backup or restore worker (SIGTERM / taskkill), marks the job `cancelled` in `athena_logging`, and allows deleting it from the Backups UI. Jobs stuck as `running` after a crash can be cancelled to clear the row.

### Documentation

- Sync `openapi.yaml` and `index.yaml` with `GET /admin/clients/{client_name}/statistics/drilldown` (client statistics operation drilldown).
- Document the route in `README.md` admin API list.
- Sync `openapi.yaml` with `POST /admin/backups/jobs/{id}/cancel`.

## [2.8.1](https://github.com/xylex-group/athena/compare/v2.8.0...v2.8.1) (2026-03-22)

### Features

- Background vacuum health collector samples `pg_stat_user_tables` and transaction ID age on each registered Postgres client and persists aggregates plus per-table rows into `vacuum_health_snapshots` and `vacuum_health_table_stats` on the `athena_logging` database. Admin routes `GET /admin/vacuum-health` and `GET /admin/vacuum-health/{client_name}` return the latest stored snapshots (static admin key).

### Documentation

- Sync `openapi.yaml` with the vacuum health admin routes.

## [2.5.7](https://github.com/xylex-group/athena/compare/v2.5.6...v2.5.7) (2026-03-19)

### Features

- Gateway fetch supports optional `sortBy` / `sort_by` in POST body (`field`, `direction`: asc/desc) for `/gateway/fetch` and `/gateway/data`. GET `/data` accepts optional `sort_by` and `sort_direction` query params. Sort is applied in Postgres (SQLx and deadpool) and Supabase drivers; cache keys include sort options.

### Documentation

- Sync `openapi.yaml` with sortBy/sort_by body parameters and GET `/data` sort_by/sort_direction query parameters.

## [2.5.0](https://github.com/xylex-group/athena/compare/v2.4.0...v2.5.0) (2026-03-17)

### Documentation

- Sync `openapi.yaml` to include Postgres extension installs (`POST /management/extensions/install`).

## [2.4.0](https://github.com/xylex-group/athena/compare/v2.3.0...v2.4.0) (2026-03-13)

### Features

- add papaparse dependency for CSV import functionality ([dceb96f](https://github.com/xylex-group/athena/commit/dceb96f763a566b0fe2ab44f6b46a05673379c40))

## [1.3.0](https://github.com/xylex-group/athena/compare/v1.2.1...v1.3.0) (2026-03-08)

### Documentation

- Sync `openapi.yaml` to include admin provisioning and S3 backup endpoints, plus refreshed README references for `/openapi.yaml` and `/openapi-wss.yaml`.
- Refresh `openapi-wss.yaml` to cover the Bun WebSocket gateway contract (`/wss/gateway`, `/wss/info`, `/health`, `/ready`) with updated request/response envelopes and README notes.

### Features

- **web:** comprehensive client application enhancements ([9417fb1](https://github.com/xylex-group/athena/commit/9417fb18fb7868e596775f4fa03f8cb706a8c94e))

## [1.2.0](https://github.com/xylex-group/athena/compare/v1.1.1...v1.2.0) (2026-03-06)

### Documentation

- Sync `openapi.yaml` with the current Rust REST routes, ensuring `/gateway/data`, `/rest/v1/{table}`, and `/openapi-wss.yaml` are documented.
- Sync `openapi-wss.yaml` with the latest GatewayWsRequest/GatewayWsResponse contract.
- Update README references so the new specs can be downloaded via `/openapi.yaml` and `/openapi-wss.yaml`.

## [2.1.0](https://github.com/xylex-group/athena/compare/v2.0.0...v2.1.0) (2026-03-03)

### Features

- Add WebSocket gateway contract endpoint to OpenAPI specification ([5f2e0f5](https://github.com/xylex-group/athena/commit/5f2e0f54e2ee2b7534b0cacc7aa0a3e0dfbd0cdf))

## [1.1.1](https://github.com/xylex-group/athena/compare/v1.0.0...v1.1.1) (2026-03-03)

### ⚠ BREAKING CHANGES

- started pipeline

### Features

- Add atabex Supabase client and update client router ([04a09fd](https://github.com/xylex-group/athena/commit/04a09fd741c20cef760d048f9b557df098baee81))
- add CLI helpers to enhance command-line functionality; update README with usage instructions and integrate clap for argument parsing ([decfd38](https://github.com/xylex-group/athena/commit/decfd382a2f5fbebe9ff506d33e2c11b9ad40d01))
- Add delete functionality to the API gateway ([e2a0353](https://github.com/xylex-group/athena/commit/e2a03536f9ebe0378c6a58adaf44433ace884af5))
- Add functions for ID comparison and data retrieval between remote and local databases in supabase_ipv4.py ([820efa0](https://github.com/xylex-group/athena/commit/820efa028a703f44d29e092d2e796c00099954a1))
- Add functions for ID retrieval and comparison between remote and local databases in supabase_ipv4.py ([b247861](https://github.com/xylex-group/athena/commit/b2478611d24b8b8d57c10075af7172e1e4be2294))
- add gateway configuration for camel case to snake case conversion ([a8e2ded](https://github.com/xylex-group/athena/commit/a8e2ded82ed4ad03071c231f4de14c4feca8121f))
- add gateway query route and update service registration in main ([a7d20e6](https://github.com/xylex-group/athena/commit/a7d20e6f9f5a9e953530ef405fd8622d75b19001))
- add gateway update route and streamline user ID handling in fetch data route ([8dee888](https://github.com/xylex-group/athena/commit/8dee8888189e8bac5d42ef51c5f822296baf0d89))
- Add insert module and update API routes in gateway ([01f1483](https://github.com/xylex-group/athena/commit/01f14838946af64f0ac591e083e94e649c06d044))
- add logging client configuration and enhance logging for gateway operations ([859fa9f](https://github.com/xylex-group/athena/commit/859fa9f7fc70e46689f8e431a2542f2494805ccf))
- add new endpoint for serving OpenAPI specification and update router registry function visibility ([bcb63b0](https://github.com/xylex-group/athena/commit/bcb63b0481c117bc89f4a4055cf2c308e24a571f))
- add new query parameters for data aggregation and grouping in openapi.yaml to enhance data processing capabilities ([0c1a3ba](https://github.com/xylex-group/athena/commit/0c1a3ba8868838941b59fdd92f01002475856702))
- add pipeline execution endpoint and enhance OpenAPI documentation; update version to 0.75.1 ([e31eb6b](https://github.com/xylex-group/athena/commit/e31eb6b9d772661402ab22685a1ca7d7c457da84))
- Add purple color support and enhance progress bar in athena.py ([b92768b](https://github.com/xylex-group/athena/commit/b92768bd2e258daad738f44abf82374b4f6763a7))
- add QueryResult struct with debug implementation and update example to demonstrate new SDK usage ([373478d](https://github.com/xylex-group/athena/commit/373478deb12a9195db34c00d12c82090bb9e1300))
- Add remote row counting functionality using Supabase API in athena.py ([c937e52](https://github.com/xylex-group/athena/commit/c937e52991fce9d6c9c94e77ed30ce3ccd4bb7ec))
- Add resource ID key for ad_accounts in insert module ([042f9a9](https://github.com/xylex-group/athena/commit/042f9a9a0c824522bb3b634a14b543a2ae8d7d5f))
- Add row count verification between remote and local databases in supabase_ipv4.py ([1776de0](https://github.com/xylex-group/athena/commit/1776de062fb6d898bc6a0908bcf9369104862292))
- Add row counting and enhanced truncate functionality in athena.py ([36054ba](https://github.com/xylex-group/athena/commit/36054ba1fbe8e0e592472c22086a34e91a767093))
- add support for overriding API port in CLI; update README with new command-line options and improve code organization in main and cli modules ([2aea752](https://github.com/xylex-group/athena/commit/2aea752ae13671fc42a470da2451089b49f9f646))
- Add tests for rehydrate check and header retrieval functions ([51bbde3](https://github.com/xylex-group/athena/commit/51bbde311f6b4b909797ac7677d02d30dd72f9d7))
- Add unit tests for request handling functions ([ec80ffe](https://github.com/xylex-group/athena/commit/ec80ffece5b6f29da33f0a8e28e5255d3566f9a8))
- add UUID support in insert operations and update response structure; enhance sqlx dependency with UUID feature ([701c3aa](https://github.com/xylex-group/athena/commit/701c3aa1aabd186b4b6e8020016433438cc619e5))
- added ssl enforcement api, chore: bump version to 0.72.0, remove deprecated SQL extensions, and add new SSL enforcement API endpoint in openapi.yaml RELEASE v0.72.0 ([a27c595](https://github.com/xylex-group/athena/commit/a27c59542bed80d9021572931721e16c38b989a7))
- **api:** add new admin API key management endpoints for creation, listing, updating, and deletion of API keys and rights, along with health check endpoint ([2807632](https://github.com/xylex-group/athena/commit/2807632a9661b1f2111d8d43774983c7e0d10eb8))
- **api:** enforce X-Athena-Client header requirement in fetch and insert routes, improve error handling for missing headers and unique constraint violations ([1d7c898](https://github.com/xylex-group/athena/commit/1d7c898fac07167d0b7ce9d64748f40d4f9fddd8))
- **api:** expand Postman collection with new endpoints for gateway updates, queries, and pipeline management, and add additional environment variables for API key management ([dcf8256](https://github.com/xylex-group/athena/commit/dcf825674d70cf4bb56bc63794c92ce548bfece9))
- **api:** implement API key authentication logging and enhance gateway request handling with authorization checks ([b6d2b21](https://github.com/xylex-group/athena/commit/b6d2b218fbdd1d2f45a40016b523feb1a24dee19))
- **config:** add new Postgres clients for Xylex Cloud and Athena retention slave; enhance module structure with daemon and health endpoints ([5621328](https://github.com/xylex-group/athena/commit/56213286aeb2faaba9d1768b10d25f13c0038cc0))
- Enhance API functionality and update dependencies ([cdbf1d6](https://github.com/xylex-group/athena/commit/cdbf1d6dcf4b3b40b0d0a230f555e6e8b4276c24))
- Enhance API with custom Supabase client support ([5f71835](https://github.com/xylex-group/athena/commit/5f71835d74d1d44b0c20d22aefde70564b8fc259))
- enhance athena_client_sdk example by adding support for Neon and Postgrest backends, simplifying Supabase client initialization ([cd68e5b](https://github.com/xylex-group/athena/commit/cd68e5b99fef60c603b4c65ff248b9df685b6eb3))
- enhance bind_value macro to support UUID parsing for string values in PostgreSQL driver ([04de309](https://github.com/xylex-group/athena/commit/04de30972d46ab72230699b9513e8d4b50ca94f4))
- enhance configuration management with detailed documentation and additional utility functions for accessing settings, RELEASE v0.73.5 ([219616a](https://github.com/xylex-group/athena/commit/219616abcf7f04610f6cf2ac554343ee2ca2d24d))
- Enhance error detection and output handling in athena.py ([34e71d2](https://github.com/xylex-group/athena/commit/34e71d21ed6a85c61164ed16c9a047937a489c32))
- enhance error handling in SQLx driver and improve identifier sanitization; add new sqlx module ([bec0992](https://github.com/xylex-group/athena/commit/bec0992c737219ef88e9f34e554210f51329af97))
- enhance gateway configuration with new HTTP settings and post-processing capabilities for data fetching ([0c48b37](https://github.com/xylex-group/athena/commit/0c48b37a3b62718a3dd40126dfb9537c9316e529))
- enhance gateway_operation_log by backfilling error, message, and cache_key columns from details metadata; ensure proper error marking for existing records ([e7b6034](https://github.com/xylex-group/athena/commit/e7b6034af54132e111f1e370bf0ce585ed3e49f5))
- Enhance insert functionality with Supabase client integration ([2d7afa9](https://github.com/xylex-group/athena/commit/2d7afa9b81a062ea00c3938b2b5136a8339b01c4))
- Enhance logging consistency in athena.py ([46a585c](https://github.com/xylex-group/athena/commit/46a585ccdf1ca00feb480c100867a488935152c9))
- Enhance role management and error handling in xbp_dumper ([d65c61d](https://github.com/xylex-group/athena/commit/d65c61db94c942b669c1be8df953fc05ef3376b8))
- Enhance row counting functionality and integrate Supabase API in athena.py ([b43ec39](https://github.com/xylex-group/athena/commit/b43ec39c77c544c0daa41e816854fc04cb19cb60))
- expose proxy fetch data route and update main service registration ([9872bcf](https://github.com/xylex-group/athena/commit/9872bcf4c3cea30767a7a6aff854f7f70a6cdb62))
- implement Athena client handling in proxy request and expose fetch data route ([1e7ae08](https://github.com/xylex-group/athena/commit/1e7ae08f75ae58c783663238e4a5fe36d66ff634))
- Implement cache management and enhance API with new caching features ([cfcc7eb](https://github.com/xylex-group/athena/commit/cfcc7eb615a4d13a8cddec313602eb852f71f319))
- implement InsertIdentity struct for improved request handling and header validation in insert operations; deprecate mandatory headers with fallback to apikey ([2f8be1a](https://github.com/xylex-group/athena/commit/2f8be1a1245df6e17d6faf472d031d24f6b9805c))
- implement normalization functions for column names and row values in gateway ([8f8c1d8](https://github.com/xylex-group/athena/commit/8f8c1d88445517faf5f46af59fa30f433afe6393))
- Integrate progress tracking and enhanced logging in athena.py ([39c5fd0](https://github.com/xylex-group/athena/commit/39c5fd018c75d88924dd587cc7269edd4da5db6e))
- Interface the Athena Gateway thru a WSS client now, fix: fixes to the athena-cdc adapter, fix: improvements to the flow of the handler, implemented a canonical handler for the wss openapi and rest openapi, feat!: added 4 new tables to allow introspecting database clients straight into the driver online without needing to reboot into a configurable ENV var , this is backwards compatible so that clients can be added ot the config online and then without restarting, only initiating that specific client ([864391c](https://github.com/xylex-group/athena/commit/864391c3037f276e1cc87bc329eb8e9c10a963dc))
- Introduce ATHENA_PREFIX for consistent logging in athena.py ([ecf1e97](https://github.com/xylex-group/athena/commit/ecf1e970173b05fdd3b77b8cd900db2a5feea4e9))
- introduce AthenaClient SDK with builder-based interface for unified database access; update README with usage examples and enhance Cargo.toml with new dependencies ([f28f7d8](https://github.com/xylex-group/athena/commit/f28f7d8f8404734e75c6670acf844a4cdb0e1044))
- introduce error processing utilities and enhance error handling in API responses; add regex dependency ([fdeab03](https://github.com/xylex-group/athena/commit/fdeab035c6383cd29a284e965daaade9f92e5a7a))
- Optimize row counting and truncation processes in athena.py ([466335d](https://github.com/xylex-group/athena/commit/466335ddea9be98cde5ca5c5ee7a5544ba56a64c))
- **redeploy:** enhance redeploy script with robust file and port handling; add crate-name parameter for improved configuration ([5a206ec](https://github.com/xylex-group/athena/commit/5a206ec9ac44adf200ebc87178535e7ed0796402))
- Refactor and enhance import process in athena.py ([39de14b](https://github.com/xylex-group/athena/commit/39de14bfd76625c483488ca4ad42408c19efdfc0))
- **schema:** add /schema/migrations endpoint to list schema migrations with graceful fallback; update API documentation and response handling ([7fec327](https://github.com/xylex-group/athena/commit/7fec32738c0398bdfe6fddc7a5d647b6dca4322e))
- **schema:** add pg_schema module and improve error handling in schema_migrations for database migration tracking ([0cf117f](https://github.com/xylex-group/athena/commit/0cf117fe51aee428c50133ccad2fd7d478a79936))
- **schema:** implement schema validation improvements and optimize migration tracking logic for enhanced reliability ([32273ed](https://github.com/xylex-group/athena/commit/32273ed090f4c6d1655af242a0c20dda0c8bd949))
- Started on the SQL -&gt; CQL translator ([1725308](https://github.com/xylex-group/athena/commit/17253088a5311308eea638be1523cf67bb15c791))
- started pipeline ([f7d6e14](https://github.com/xylex-group/athena/commit/f7d6e1448d8bbad725e9a0209980b4750c112564))
- updated extra docs, RELEASE v0.72.3 ([ccf0926](https://github.com/xylex-group/athena/commit/ccf09268c6f2f817c9b309d51d0f3f953695cdd5))

### Bug Fixes

- added some caching to the ping endpoint ([feaeb05](https://github.com/xylex-group/athena/commit/feaeb05e32c7797121273ecf598f49995708471f))
- amended psql clients usage in config ([20ca86d](https://github.com/xylex-group/athena/commit/20ca86d1d820f7325e5d402e1374a81d726a7a35))
- **api:** enhance error handling in API responses to improve user experience and debugging ([dd2c5fa](https://github.com/xylex-group/athena/commit/dd2c5faf223dbf511884fb75e0217d6a33180338))
- **api:** enhance error handling in gateway update route by introducing structured error logging and response formatting ([8fff733](https://github.com/xylex-group/athena/commit/8fff7338c959b40046ca004db52d552dd875085e))
- **api:** trim trailing semicolons from SQL queries to prevent empty query errors ([31db595](https://github.com/xylex-group/athena/commit/31db59554032f5838d549c1c51880039c1eb387b))
- Clean up whitespace in athena.py ([306d75f](https://github.com/xylex-group/athena/commit/306d75f83b6c6939be9b44104943fb3ae4a25e4a))
- Correct import order for Supabase client in insert module ([ce6fc8a](https://github.com/xylex-group/athena/commit/ce6fc8abcdae676f616f99d8b00d9be7b1b67005))
- Correct ScyllaDB column listing query variable type ([db30cf0](https://github.com/xylex-group/athena/commit/db30cf0a67a2d5a316f6d4048108c8e5cfb0f687))
- correct type annotation for routes in ping function and update online message capitalization ([7959adb](https://github.com/xylex-group/athena/commit/7959adb7650a56a1d32455d20fd66b37ab28f145))
- **driver:** bind UUID only in SET/INSERT; keep WHERE values as text ([d42b725](https://github.com/xylex-group/athena/commit/d42b7255a5783702e5b51771f09db29a9895769d))
- **driver:** bind UUID-shaped strings as UUID type for Postgres UUID columns ([70d38e0](https://github.com/xylex-group/athena/commit/70d38e0a9a6dac7b3357a340c2ff57fdcdcc9692))
- Enhance row count parsing in get_local_row_count function in supabase_ipv4.py ([a67347c](https://github.com/xylex-group/athena/commit/a67347c1cd7a1f71e0387b817e3080e8fbf4e501))
- **gateway:** pass table name only to update_rows to avoid invalid table name ([c46bfa3](https://github.com/xylex-group/athena/commit/c46bfa355ce18113a7e289ba9c42195bf36ea57e))
- **gateway:** perform UPDATE in POST /gateway/update instead of fetch ([218a5dc](https://github.com/xylex-group/athena/commit/218a5dc01c2c6993e0e2a0d2b026d15ee5b1a78a))
- Improve error handling and parsing in row counting functions in athena.py ([c8b46f6](https://github.com/xylex-group/athena/commit/c8b46f6da1a6ca7b7f9cbd04e8c5bfe615b0e0ab))
- Improve parsing logic in count_rows_local function in athena.py ([a7da1e8](https://github.com/xylex-group/athena/commit/a7da1e886a551f8419fbef1feb0efefbbf09393f))
- **parser:** cast UUID condition values to ::uuid in WHERE clause ([73afe35](https://github.com/xylex-group/athena/commit/73afe35e40a4605f3f1e229a13d4fd051f23862f))
- **parser:** compare UUID-shaped values as text for both UUID and TEXT columns ([fb06251](https://github.com/xylex-group/athena/commit/fb0625128bbb77ca10a52684c763acc15998d075))
- **redeploy:** enhance load_defaults function to dynamically locate xbp.json file in multiple potential paths ([70549df](https://github.com/xylex-group/athena/commit/70549dfcf4c80949f0b44e045b6a82b3bd2499d6))
- Refine row count parsing and error handling in count_rows_local function in athena.py ([c063461](https://github.com/xylex-group/athena/commit/c063461543440557c1b6cb814dbd9c6cdc366c8d))
- remove trailing comma in config.yaml for correct YAML syntax ([7ed028b](https://github.com/xylex-group/athena/commit/7ed028b6fffa4076bf0a5dc5fac6d4ed1335935d))
- Specify type for query variable in ScyllaDB column listing ([c15d941](https://github.com/xylex-group/athena/commit/c15d941f4f7df28096c6b2bb0ce78ac35d520eb7))
- SUI-1780 ([4ff8d98](https://github.com/xylex-group/athena/commit/4ff8d98321f9862ef63b0f3b94a8b6d412392e0f))
- update Dockerfile CMD to include API options and enhance openapi.yaml with formatting improvements; add new documentation for Docker compose usage in README.md ([f6abebf](https://github.com/xylex-group/athena/commit/f6abebfa2d8ede72ea4a1e53418f5760d9c5cf75))
- update OpenAPI paths to use consistent double quotes and rename endpoints for gateway integration, RELEASE v0.75.1 ([05c29ae](https://github.com/xylex-group/athena/commit/05c29aee3eb09688c610554c5600785b8236c426))
- Update ScyllaDB host configuration and enhance delete event handling ([2f49de5](https://github.com/xylex-group/athena/commit/2f49de5a6079631cd1ae7c13200d450736d7060b))
- Update ScyllaDB host in configuration file ([67185a7](https://github.com/xylex-group/athena/commit/67185a70c74f3702b9e6730ec6188553d2df84d5))

## [1.0.0](https://github.com/xylex-group/athena/compare/v0.71.0...v1.0.0) (2026-03-03)

### ⚠ BREAKING CHANGES

- started pipeline

### Features

- add CLI helpers to enhance command-line functionality; update README with usage instructions and integrate clap for argument parsing ([decfd38](https://github.com/xylex-group/athena/commit/decfd382a2f5fbebe9ff506d33e2c11b9ad40d01))
- add logging client configuration and enhance logging for gateway operations ([859fa9f](https://github.com/xylex-group/athena/commit/859fa9f7fc70e46689f8e431a2542f2494805ccf))
- add new endpoint for serving OpenAPI specification and update router registry function visibility ([bcb63b0](https://github.com/xylex-group/athena/commit/bcb63b0481c117bc89f4a4055cf2c308e24a571f))
- add pipeline execution endpoint and enhance OpenAPI documentation; update version to 0.75.1 ([e31eb6b](https://github.com/xylex-group/athena/commit/e31eb6b9d772661402ab22685a1ca7d7c457da84))
- add QueryResult struct with debug implementation and update example to demonstrate new SDK usage ([373478d](https://github.com/xylex-group/athena/commit/373478deb12a9195db34c00d12c82090bb9e1300))
- add support for overriding API port in CLI; update README with new command-line options and improve code organization in main and cli modules ([2aea752](https://github.com/xylex-group/athena/commit/2aea752ae13671fc42a470da2451089b49f9f646))
- add UUID support in insert operations and update response structure; enhance sqlx dependency with UUID feature ([701c3aa](https://github.com/xylex-group/athena/commit/701c3aa1aabd186b4b6e8020016433438cc619e5))
- added ssl enforcement api, chore: bump version to 0.72.0, remove deprecated SQL extensions, and add new SSL enforcement API endpoint in openapi.yaml RELEASE v0.72.0 ([a27c595](https://github.com/xylex-group/athena/commit/a27c59542bed80d9021572931721e16c38b989a7))
- **api:** add new admin API key management endpoints for creation, listing, updating, and deletion of API keys and rights, along with health check endpoint ([2807632](https://github.com/xylex-group/athena/commit/2807632a9661b1f2111d8d43774983c7e0d10eb8))
- **api:** enforce X-Athena-Client header requirement in fetch and insert routes, improve error handling for missing headers and unique constraint violations ([1d7c898](https://github.com/xylex-group/athena/commit/1d7c898fac07167d0b7ce9d64748f40d4f9fddd8))
- **api:** expand Postman collection with new endpoints for gateway updates, queries, and pipeline management, and add additional environment variables for API key management ([dcf8256](https://github.com/xylex-group/athena/commit/dcf825674d70cf4bb56bc63794c92ce548bfece9))
- **api:** implement API key authentication logging and enhance gateway request handling with authorization checks ([b6d2b21](https://github.com/xylex-group/athena/commit/b6d2b218fbdd1d2f45a40016b523feb1a24dee19))
- **config:** add new Postgres clients for Xylex Cloud and Athena retention slave; enhance module structure with daemon and health endpoints ([5621328](https://github.com/xylex-group/athena/commit/56213286aeb2faaba9d1768b10d25f13c0038cc0))
- enhance athena_client_sdk example by adding support for Neon and Postgrest backends, simplifying Supabase client initialization ([cd68e5b](https://github.com/xylex-group/athena/commit/cd68e5b99fef60c603b4c65ff248b9df685b6eb3))
- enhance bind_value macro to support UUID parsing for string values in PostgreSQL driver ([04de309](https://github.com/xylex-group/athena/commit/04de30972d46ab72230699b9513e8d4b50ca94f4))
- enhance configuration management with detailed documentation and additional utility functions for accessing settings, RELEASE v0.73.5 ([219616a](https://github.com/xylex-group/athena/commit/219616abcf7f04610f6cf2ac554343ee2ca2d24d))
- enhance error handling in SQLx driver and improve identifier sanitization; add new sqlx module ([bec0992](https://github.com/xylex-group/athena/commit/bec0992c737219ef88e9f34e554210f51329af97))
- enhance gateway_operation_log by backfilling error, message, and cache_key columns from details metadata; ensure proper error marking for existing records ([e7b6034](https://github.com/xylex-group/athena/commit/e7b6034af54132e111f1e370bf0ce585ed3e49f5))
- implement InsertIdentity struct for improved request handling and header validation in insert operations; deprecate mandatory headers with fallback to apikey ([2f8be1a](https://github.com/xylex-group/athena/commit/2f8be1a1245df6e17d6faf472d031d24f6b9805c))
- Interface the Athena Gateway thru a WSS client now, fix: fixes to the athena-cdc adapter, fix: improvements to the flow of the handler, implemented a canonical handler for the wss openapi and rest openapi, feat!: added 4 new tables to allow introspecting database clients straight into the driver online without needing to reboot into a configurable ENV var , this is backwards compatible so that clients can be added ot the config online and then without restarting, only initiating that specific client ([864391c](https://github.com/xylex-group/athena/commit/864391c3037f276e1cc87bc329eb8e9c10a963dc))
- introduce AthenaClient SDK with builder-based interface for unified database access; update README with usage examples and enhance Cargo.toml with new dependencies ([f28f7d8](https://github.com/xylex-group/athena/commit/f28f7d8f8404734e75c6670acf844a4cdb0e1044))
- introduce error processing utilities and enhance error handling in API responses; add regex dependency ([fdeab03](https://github.com/xylex-group/athena/commit/fdeab035c6383cd29a284e965daaade9f92e5a7a))
- **redeploy:** enhance redeploy script with robust file and port handling; add crate-name parameter for improved configuration ([5a206ec](https://github.com/xylex-group/athena/commit/5a206ec9ac44adf200ebc87178535e7ed0796402))
- **schema:** add /schema/migrations endpoint to list schema migrations with graceful fallback; update API documentation and response handling ([7fec327](https://github.com/xylex-group/athena/commit/7fec32738c0398bdfe6fddc7a5d647b6dca4322e))
- **schema:** add pg_schema module and improve error handling in schema_migrations for database migration tracking ([0cf117f](https://github.com/xylex-group/athena/commit/0cf117fe51aee428c50133ccad2fd7d478a79936))
- **schema:** implement schema validation improvements and optimize migration tracking logic for enhanced reliability ([32273ed](https://github.com/xylex-group/athena/commit/32273ed090f4c6d1655af242a0c20dda0c8bd949))
- started pipeline ([f7d6e14](https://github.com/xylex-group/athena/commit/f7d6e1448d8bbad725e9a0209980b4750c112564))
- updated extra docs, RELEASE v0.72.3 ([ccf0926](https://github.com/xylex-group/athena/commit/ccf09268c6f2f817c9b309d51d0f3f953695cdd5))

### Bug Fixes

- **api:** enhance error handling in API responses to improve user experience and debugging ([dd2c5fa](https://github.com/xylex-group/athena/commit/dd2c5faf223dbf511884fb75e0217d6a33180338))
- **api:** enhance error handling in gateway update route by introducing structured error logging and response formatting ([8fff733](https://github.com/xylex-group/athena/commit/8fff7338c959b40046ca004db52d552dd875085e))
- **api:** trim trailing semicolons from SQL queries to prevent empty query errors ([31db595](https://github.com/xylex-group/athena/commit/31db59554032f5838d549c1c51880039c1eb387b))
- correct type annotation for routes in ping function and update online message capitalization ([7959adb](https://github.com/xylex-group/athena/commit/7959adb7650a56a1d32455d20fd66b37ab28f145))
- **driver:** bind UUID only in SET/INSERT; keep WHERE values as text ([d42b725](https://github.com/xylex-group/athena/commit/d42b7255a5783702e5b51771f09db29a9895769d))
- **driver:** bind UUID-shaped strings as UUID type for Postgres UUID columns ([70d38e0](https://github.com/xylex-group/athena/commit/70d38e0a9a6dac7b3357a340c2ff57fdcdcc9692))
- **gateway:** pass table name only to update_rows to avoid invalid table name ([c46bfa3](https://github.com/xylex-group/athena/commit/c46bfa355ce18113a7e289ba9c42195bf36ea57e))
- **gateway:** perform UPDATE in POST /gateway/update instead of fetch ([218a5dc](https://github.com/xylex-group/athena/commit/218a5dc01c2c6993e0e2a0d2b026d15ee5b1a78a))
- **parser:** cast UUID condition values to ::uuid in WHERE clause ([73afe35](https://github.com/xylex-group/athena/commit/73afe35e40a4605f3f1e229a13d4fd051f23862f))
- **parser:** compare UUID-shaped values as text for both UUID and TEXT columns ([fb06251](https://github.com/xylex-group/athena/commit/fb0625128bbb77ca10a52684c763acc15998d075))
- **redeploy:** enhance load_defaults function to dynamically locate xbp.json file in multiple potential paths ([70549df](https://github.com/xylex-group/athena/commit/70549dfcf4c80949f0b44e045b6a82b3bd2499d6))
- update Dockerfile CMD to include API options and enhance openapi.yaml with formatting improvements; add new documentation for Docker compose usage in README.md ([f6abebf](https://github.com/xylex-group/athena/commit/f6abebfa2d8ede72ea4a1e53418f5760d9c5cf75))
- update OpenAPI paths to use consistent double quotes and rename endpoints for gateway integration, RELEASE v0.75.1 ([05c29ae](https://github.com/xylex-group/athena/commit/05c29aee3eb09688c610554c5600785b8236c426))
