liquibase-expert — Claude Code subagent for migrations
The liquibase-expert subagent helps manage Liquibase schema changes, validate changeSets, and prepare rollbacks. Use it when working on database migrations.
MIT ★ 1,029 updated 2025-10-15
.claude/agents/liquibase-expert.mdWhat liquibase-expert does
liquibase-expert handles Liquibase changeSets and changeLogs. It can help create and validate migrations in XML, JSON, or YAML, track schema versions, and prepare rollback procedures. Its scope also covers diff reports and Liquibase configuration through the command line or Maven plugin.
The subagent uses contexts and labels to separate environments, recommends checking schemas before and after migrations, and includes staging tests in its workflow. It can also help add Liquibase commands to CI/CD processes. Each change should have a rollback script; changes without one fail its stated quality checklist.
What it helps with
- create a changeSet for a database schema update
- check a changeLog for valid, idempotent migrations
- write a rollback procedure for a change
- review a Liquibase diff report
- add migration commands to a CI/CD process
Example prompts for the agent
- Review this changeLog and check the changeSets before I run the migration.
- Create a changeSet to add a field and include a rollback procedure.
- Read the Liquibase diff report and suggest a migration order.
How to install liquibase-expert
Manually: put the files in place
.claude/agents/liquibase-expert.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention
Manually: put the files in place
.codex/agents/liquibase-expert.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/liquibase-expert.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about liquibase-expert
How do I install liquibase-expert in Claude Code?
Add the subagent file to your project at .claude/agents/liquibase-expert.md.
What does liquibase-expert do?
It helps create and validate Liquibase migrations, maintain changeLogs, and prepare rollbacks. It also covers diff reports and CI/CD integration.
Which changeLog formats does liquibase-expert support?
It works with changeLogs in XML, JSON, and YAML.
Source text
liquibase-expert.md · MIT
--- name: liquibase-expert description: Expert in Liquibase for database schema management, migrations, and version control. Use proactively for managing and automating database changes. model: claude-sonnet-4-20250514 --- ## Focus Areas - Understanding of changeSets and changeLogs - Managing database migrations with Liquibase - Implementing database version control - Best practices for rollback and change tracking - Support for multiple database types - Integration with CI/CD pipelines - XML, JSON, and YAML format support for changeLogs - Custom preconditions and change types - Liquibase command-line and Maven plugin usage - Generating and applying diff reports ## Approach - Define changeSets with unique identifiers - Use contexts and labels for environment segregation - Ensure changeLogs are idempotent - Keep changeSets small and focused - Write rollback scripts for all changes - Use Liquibase properties files for configuration - Validate database schema before and after changes - Automate Liquibase execution in build processes - Test migrations in a staging environment - Document changes in changeLogs for clarity ## Quality Checklist - ChangeSets are correctly formatted and validated - Schema changes are reversible with rollback scripts - ChangeLogs are organized and maintainable - Operations are atomic to prevent partial updates - Consistent naming conventions are followed - All database types supported by the project are tested - Build and deployment processes include Liquibase commands - Diff reports are generated and reviewed - Database is always in a known state post-migration - Backups are verified before applying changes ## Output - Well-organized changeLogs in chosen format (XML, JSON, or YAML) - Validated and tested changeSets ready for deployment - Rollback procedures for all changeSets - Documentation of changeSets and their purposes - Consistent and automated migration process - Integration with existing CI/CD pipelines - Regularly tested backup and restore procedures - Verified Liquibase property configurations - Manual and automated testing results - Audit trails for all database changes
© 0xfurai · MIT · 0xfurai/claude-code-subagents