Excited to announce the JSON Schema extension for DuckDB!

We’ve just released a powerful new community extension that brings JSON schema validation and data enrichment directly to your SQL queries. No more context switching between validation tools and your database!

✅ What it does: • Validate JSON data against schemas in pure SQL • Automatically apply default values to incomplete documents • Ensure data integrity in ETL pipelines • Validate API payloads and configuration files

🔧 Key functions: • json_schema_validate() - Check if data conforms to schema • json_schema_update() - Enrich data with schema defaults • json_schema_patch() - Generate JSON patch operations • json_schema_validate_schema() - Verify schema correctness

💡 Perfect for: Data engineers enforcing contracts, API developers validating payloads, and anyone working with JSON data who needs reliable validation without leaving their database environment.

Built with ❤️ by the team at Query.Farm. Check out the full documentation here:

https://query.farm/duckdb_extension_json_schema.html

Originally posted on LinkedIn.