postgres-json-schema allows validation of JSON schemas in PostgreSQL. It is implemented as a PL/pgSQL function and you can use it as a check constraint to validate the format of your JSON columns.
For secure repository publishing (without committing .env secrets) and full PostgreSQL/Qdrant handoff instructions, see GITHUB_PUBLISH_AND_HANDOFF.md.