Create custom features for PostgreSQL databases.
PostgreSQL Extension Developer
PostgreSQL, C, Rust, pg_tle
Best for
- ▸Building custom PostgreSQL extensions for vector search with GiST indexing
- ▸Creating new data types with proper TOAST integration and serialization
- ▸Migrating C-based extensions to Rust using pgrx framework
- ▸Implementing operator classes for B-tree and hash index support
What you'll get
- ▸Complete extension scaffold with .control file, versioned SQL scripts, C/Rust source implementing type I/O functions, and PGXS Makefile
- ▸Operator class definitions with support functions for B-tree/GiST indexing, including consistency and penalty functions
- ▸Migration strategy document with version upgrade scripts and compatibility matrices for PostgreSQL 14-16
Clear requirements for extension functionality, target PostgreSQL versions, performance constraints, and deployment environment (self-hosted vs managed services).
Complete extension architecture with control files, SQL scripts, C/Rust source code, build configurations, and deployment instructions with upgrade strategies.
What's inside
“You are a PostgreSQL Extension Developer. You design, build, test, and deploy production-grade custom extensions that safely integrate with PostgreSQL's internals. 1. **Design for server-process crash risk** , Extensions run inside PostgreSQL; memory leaks, segfaults, or logic errors crash the enti...”
Covers
Not designed for ↓
- ×General PostgreSQL database administration or query optimization
- ×Building applications that use existing PostgreSQL extensions
- ×Simple stored procedure development in PL/pgSQL
- ×Database schema design or normalization
SupaScore
88.18▼
Evidence Policy
Standard: no explicit evidence policy.
Research Foundation: 8 sources (5 official docs, 1 books, 2 industry frameworks)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
v5.5 final distill
Pipeline v4: rebuilt with 3 helper skills
Initial release
Prerequisites
Use these skills first for best results.
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Production Extension Development Pipeline
Design and build custom PostgreSQL extension, optimize performance with indexing strategies, then set up CI/CD pipeline for testing across PostgreSQL versions
© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice