Automated summary
Analyzes Liquibase changelogs, generates standard SQL DDL for draw.io import, and performs a schema architecture review.
Strengths
- Synthesizes the final schema state from Liquibase migrations.
- Produces a DDL script that can be pasted directly into draw.io.
- Provides focused critique on foreign-key indexes, normalization, naming conventions, and JPA/Hibernate practices.
Limitations
- Depends on the completeness of the supplied changelogs.
- Does not connect to a live database or execute migrations.
- draw.io SQL import behavior may vary by tool version.
Use when a database diagram needs updating or when a new Liquibase migration requires an architecture review.
Avoid it when you need to validate the schema against a production database or when the project does not use Liquibase.
Security analysis
SafeThe skill only reads Liquibase changelog files, synthesizes schema DDL, and provides architectural review guidance. It declares no tools, executes no commands, and contains no destructive, exfiltration, obfuscated, or safety-disabling instructions.
No concerns found
How this analysis is madeExamples
Read the Liquibase changelogs in src/main/resources/db/changelog, synthesize the final schema as CREATE TABLE statements, and give me the SQL block to paste into draw.io.Review the latest Liquibase migration for missing indexes on foreign keys, normalization issues, naming consistency, and Spring Boot JPA/Hibernate alignment.Our draw.io ER diagram is outdated; derive the current database schema from the Liquibase changelogs and critique the architecture before I update the diagram.name: liquibase-drawio-reviewer description: Analyzes Liquibase changelogs, generates standard SQL DDL for draw.io imports, and conducts a schema architecture review. compatibility: opencode
What I do
- Read the project's Liquibase XML/YAML changelogs.
- Translate the changelogs into standard SQL DDL (
CREATE TABLEstatements). - Output the DDL specifically formatted for draw.io.
- Act as a senior database architect to review the schema design.
When to use me
Invoke this skill whenever a database diagram update is needed, or when reviewing the architecture of new Liquibase migrations.
Instructions
- Find and read the Liquibase changelog files (typically in
src/main/resources/db/changelog/). - Synthesize the migrations to determine the current, final state of the database schema.
- Generate a clean SQL DDL script representing this final state. Exclude
INSERTstatements or Liquibase metadata tables. - Present the SQL script in a
sqlcode block, and briefly remind the user to paste it into draw.io via Arrange > Insert > Advanced > SQL. - Provide a critical architectural critique of the schema, checking for:
- Missing indexes on foreign keys.
- Normalization issues or redundant columns.
- Naming convention consistency.
- Alignment with Spring Boot Data JPA / Hibernate best practices.
From the file to a first result
The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.
View the source and supporting filesThis download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.
1. Download the file
Download SKILL.mdFrom the root of a test project, save the file as .skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.
Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.
mkdir -p '.skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/liquibase-changelog-analyzer-ddl-generator-mryiqib2/download' --output '.skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2/SKILL.md.part' && mv '.skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2/SKILL.md.part' '.skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2/SKILL.md'2. Check prerequisites
Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.
Environment declared by the author: opencode
No recognized prerequisites section in this file. This does not mean it is self-contained: libraries, tools and access requirements may be mentioned elsewhere in the content or source repository.
The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.
3. Load the skill
After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.
OpenSkills
OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.
Official OpenSkills installationopenskills install './.skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2'openskills read 'liquibase-changelog-analyzer-ddl-generator-mryiqib2'Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.
For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.
openskills syncManual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.
4. Try a first task
Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:
Read .skill-downloads/liquibase-changelog-analyzer-ddl-generator-mryiqib2/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.
React Hook Form Best Practices
Development
Master React Hook Form: avoid anti-patterns, manage subscriptions, and handle reset, dirty state, and controlled inputs correctly.
Emotion to Mantine Migration
Development
Migrate Emotion styled-components to Mantine components with style props and CSS modules. Use when converting .styled.tsx files or removing @emotion imports.
Scope Creep Detector
Development
Analyzes git diffs against a stated intent to detect scope creep, unrelated files, broad PRs, and oversized changes, then suggests keep, split, or justify actions.