> For the complete documentation index, see [llms.txt](https://developer.harness.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.harness.io/roadmap/database-devops.md).

# Database DevOps

Explore planned Database DevOps capabilities and enhancements.

This page tracks planned capabilities and enhancements for Database DevOps.

SaaS release status: GA, SMP release status: GA

### Recently Delivered

What has been released in the last \~2 Quarters

<table data-column-title-hidden data-view="cards" data-search="true"><thead><tr><th>Tag<select multiple><option value="database-support" label="Database Support" color="blue"></option><option value="core-features" label="Core Features" color="blue"></option><option value="ai" label="AI" color="blue"></option><option value="q3" label="Q3" color="blue"></option><option value="q2" label="Q2" color="blue"></option></select></th><th>Title</th><th>Description</th></tr></thead><tbody><tr><td><span data-option="database-support">Database Support, </span><span data-option="q3">Q3</span></td><td><strong>Oracle Native Executor</strong></td><td>leverage native oracle cli to deploy your changes when using liquibase.</td></tr><tr><td><span data-option="database-support">Database Support, </span><span data-option="q3">Q3</span></td><td><strong>MS SQL Native Executor</strong></td><td>leverage native MS SQL cli to deploy your changes when using liquibase.</td></tr><tr><td><span data-option="core-features">Core Features, </span><span data-option="ai">AI, </span><span data-option="q3">Q3</span></td><td><strong>Database Change Impact Analysis</strong></td><td>Automatically analyze changes against db metadata before applying to surface possible unintended consequences.</td></tr><tr><td><span data-option="ai">AI, </span><span data-option="q3">Q3</span></td><td><strong>AI Authoring Rules Support</strong></td><td>can now centrally define rules when using AI change authoring.</td></tr><tr><td><span data-option="core-features">Core Features, </span><span data-option="q2">Q2</span></td><td><strong>Pin Image UI</strong></td><td>Allow pinning drone images through project settings instead of only via API</td></tr><tr><td><span data-option="core-features">Core Features, </span><span data-option="q2">Q2</span></td><td><strong>Execution Time Optimization Part 2</strong></td><td>Optomize liquibase container execution time.</td></tr></tbody></table>

### Now

Currently under active development, \~ current quarter

<table data-column-title-hidden data-view="cards" data-search="true"><thead><tr><th>Tag<select multiple><option value="core-features" label="Core Features" color="blue"></option><option value="database-support" label="Database Support" color="blue"></option><option value="integrations" label="Integrations" color="blue"></option><option value="ai" label="AI" color="blue"></option><option value="authentication" label="Authentication" color="blue"></option></select></th><th>Title</th><th>Description</th></tr></thead><tbody><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Onboarding Wizard</strong></td><td>guided setup experience for new users</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>BigTable support</strong></td><td>support applying database changes to Google BigTable. Currently available in Beta for everything except Author DB Change.</td></tr><tr><td><span data-option="integrations">Integrations</span></td><td><strong>ECS Runner Support</strong></td><td>support using DB DevOps with an ECS runner instead of requiring a Kubernetes delegate. Currently available within 1 AWS account in Beta.</td></tr><tr><td><span data-option="core-features">Core Features, </span><span data-option="ai">AI</span></td><td><strong>AI Author DB Change - v2</strong></td><td>simplify setup of AI Authorings ability to open a PR for the generated change.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Execution Time Optimization Part 3</strong></td><td>further decrease container account and execution time of DBD steps.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Governance for MongoDB/BigTable</strong></td><td>Allow OPA policies to analyze the yaml of a change, not just the SQL it compiles to.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Simplify Pipeline Config</strong></td><td>Simplify configuration of several pipeline DB Change patterns.</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Cassandra support</strong></td><td>Support using Database DevOps with Cassandra.</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Databricks support</strong></td><td>Support using Database DevOps with Databricks.</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Neo4j support</strong></td><td>Support using Database DevOps with Neo4j.</td></tr><tr><td><span data-option="authentication">Authentication</span></td><td><strong>Entra Auth support</strong></td><td>Support using Entra Authentication with Azure databases.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Relationship Diagram</strong></td><td>Visual diagram of the tables that currently exist in the database and how they relate.</td></tr><tr><td><span data-option="integrations">Integrations</span></td><td><strong>ProxySQL Support</strong></td><td>Add support for using proxySQL to switch which database instance traffic is routed to for database blue/green deployments.</td></tr><tr><td><span data-option="ai">AI</span></td><td><strong>LLM Authoring Files Support</strong></td><td>Add support for using LLM Authoring for changes that span multiple changelog files.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>OOTB Policy Library</strong></td><td>Out of the box example OPS policies in the product.</td></tr></tbody></table>

### Next

What we'll build next, next \~2 quarters

<table data-column-title-hidden data-view="cards" data-search="true"><thead><tr><th>Tag<select multiple><option value="database-support" label="Database Support" color="blue"></option><option value="core-features" label="Core Features" color="blue"></option></select></th><th>Title</th><th>Description</th></tr></thead><tbody><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Databricks Support 2.0</strong></td><td>additional change types when using databricks</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Support: Procedures, triggers, functions</strong></td><td>Add first class change types and diff supports for several additional db object types</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Drift Detection (Liquibase)</strong></td><td>Native, fully automated, visual drift detection, when deploying using liquibase</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>State-Based Migrations</strong></td><td>Ability to deploy all deltas in a db snapshot to the DB as a changetype</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>DACPACs Support</strong></td><td>a first class changetype for syncing a MSSQL database to the schema state in a microsoft dacpac</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>DynamoDB support</strong></td><td>support applying database changes to Amazon DynamoDB</td></tr></tbody></table>

### Future

typically > 6 months out

<table data-column-title-hidden data-view="cards" data-search="true"><thead><tr><th>Tag<select multiple><option value="core-features" label="Core Features" color="blue"></option><option value="ai" label="AI" color="blue"></option><option value="database-support" label="Database Support" color="blue"></option><option value="orchestration" label="Orchestration" color="blue"></option></select></th><th>Title</th><th>Description</th></tr></thead><tbody><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Auto-gen Rollback Scripts</strong></td><td>Automatically generate rollback scripts at rollback time for changes that lack them.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Rollback without Custom Pipeline</strong></td><td>Allow automated rollback through UI without authoring a custom pipeline.</td></tr><tr><td><span data-option="core-features">Core Features, </span><span data-option="ai">AI</span></td><td><strong>AI Index Optomization</strong></td><td>Automatically identify slow queries, and review indexes, and open PRs to optomize.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Native Local Dev</strong></td><td>Seemlessly run DBD SaaS pipelines through a cli locally.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Automated DB Testing</strong></td><td>Natively support frameworks like DBFit and DBUnit.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Refactoring Change Types</strong></td><td>First class change types for high-level complex changes that can be done with 0 downtime</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Cross-ENV Checksum enforcement</strong></td><td>Further enforce that changes are always consistent across environments</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Test Data Generation</strong></td><td>generated anonymized synthetic test data for use in staging environments</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Xenv Relationship Diagram Diff</strong></td><td>Allow an object-level diff view of what tables/objects existign in the database on the relationship diagram</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Support for AWS Redshift</strong></td><td>Add support for the AWS Redshift database as a supported database type.</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Support for Couchbase</strong></td><td>Add support for the Couchbase database as a supported database type.</td></tr><tr><td><span data-option="database-support">Database Support</span></td><td><strong>Support for Teradata</strong></td><td>Add support for the Teradata database as a supported database type.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>DB Provisioning</strong></td><td>integrate to Harness IACM to simplify DB provisioning and handling of ephemeral database environments.</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Changelog Generation</strong></td><td>Automatically generate a baseline changelog from an existing database config without authoring a custom pipeline</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Query Console</strong></td><td>Allow developers to run ad-hoc read queries against DBs, with an ability to anonymize results</td></tr><tr><td><span data-option="core-features">Core Features</span></td><td><strong>Drift Detection (Flyway)</strong></td><td>Detect and surface schema differences between a database and its expected state for flyway schema types</td></tr><tr><td><span data-option="orchestration">Orchestration</span></td><td><strong>Variablized JDBC URL</strong></td><td>Allow referencing properties from a database instance inside the JDBC URL of a database connector.</td></tr></tbody></table>

{% @harness-feedback/feedback module="roadmap" pagePath="roadmap/database-devops" %}