Codex SQL Compatibility Checks for SQLite and PostgreSQL
Replay schema SQL in memory and flag likely dialect-specific constructs before they enter a shared startup schema.
中文Install in Codex
Codex, the pinned OfferPilot checkout, Python, and uv. Use a local practice file.
- Copy the pinned `.codex/skills/sql-compat-validator/` directory into `.agents/skills/sql-compat-validator/` in the project.
- Select `$sql-compat-validator`, retain the repository checker, and provide the target SQL file.
Example task
Put a backtick-quoted column in a sample schema. Ask which parts of the shared startup SQL may need portability review.What to check
The result separates SQLite execution from portability warnings and identifies what remains to test in PostgreSQL.
Original SKILL.md on GitHub · Updated
Frequently asked question
Does a clean SQLite replay prove PostgreSQL compatibility?
It flags risk. Verify PostgreSQL behavior in an appropriate environment.