---
description: PostgreSQL version compatibility, deployment options, and database management requirements for Aidbox FHIR server.
---

# PostgreSQL Requirements

Aidbox uses PostgreSQL as its database engine, leveraging its robust JSON capabilities, reliability, and performance for healthcare data storage.

## Version compatibility

* Minimum: PostgreSQL 12 (required for JSON path support). For older versions, use PostgreSQL with `jsonknife` extension
* Actively supported: Most recent versions (currently 18, 17, 16)

## Deployment options

Compatible with all PostgreSQL deployments

* cloud-managed services (such as [AWS RDS](../deployment-and-maintenance/deploy-aidbox/run-aidbox-on-managed-postgresql.md#aurora-postgresql), [Google Cloud SQL](https://cloud.google.com/sql/postgresql), [Azure Database](../deployment-and-maintenance/deploy-aidbox/run-aidbox-on-managed-postgresql.md#azure-database-for-postgresql-flexible-server), [Databricks Lakebase](https://www.databricks.com/product/lakebase), etc)
* self-hosted installations 
* on-premises deployments

## Database Management

* **Initialization**: Aidbox automatically creates all database objects, including tables, starting indexes, and other required structures
* **Schema migrations**: Automatically handled during Aidbox version upgrades
* **Monitoring**: 
  * Aidbox provides [OpenTelemetry metrics for PostgreSQL monitoring](../modules/observability/metrics/technical-reference/opentelemetry-metrics.md#postgres)
* **Backup/Restore**: Use standard PostgreSQL methods:
  * Native PostgreSQL backup tools
  * Cloud provider solutions
  * Kubernetes operators
  * Custom scripts

## What's next

1. Check [Database Schema](database-schema.md) for technical details on schema and query capabilities.
2. Required and optional [PostgreSQL Extensions](postgresql-extensions.md)