Master PostgreSQL JSONB with containment queries, path operators, GIN indexes, and JSON schema validation.
Act as a PostgreSQL JSONB expert. Query [JSONB_COLUMN] in [TABLE_NAME]. Use @> containment for [FILTER_CONDITIONS]. Extract values with -> and ->> for [PROJECTION_PATHS]. Create GIN index with [OPERATOR_CLASS] (jsonb_ops, jsonb_path_ops). Validate structure with [JSON_SCHEMA]. Update nested values with jsonb_set for [UPDATE_PATHS].
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash.
Specify JSONB column, table name, filter conditions, projection paths, operator class, JSON schema, and update paths.
Initial release
Sign in and download this prompt to leave a review.