InsForge Skills

PostgreSQL schema patterns for the developer community. Maintained by InsForge.

What's Included

Skill: postgres-schema-patterns

Production-ready patterns for common app features:

• Social graph (follows, connections)
• Likes, favorites, bookmarks
• Nested comments & threads
• Multi-tenant / SaaS organizations

Each pattern includes:

• Schema with constraints & indexes
• Row Level Security (RLS) policies
• SDK query examples
• Performance best practices

Works with any PostgREST-based backend.

Installation

npx skills add InsForge/insforge-skills

If you're using Claude Code, you can also install this skill as a plugin:

/plugin marketplace add InsForge/insforge-skills
/plugin install postgres-schema-patterns@insforge-agent-skills

Or browse available plugins with /plugin and select from the Discover tab.

Usage

The skill automatically activates when designing database schemas:

You: "I need to build a social media app with follows and likes"

Claude: [Loads postgres-schema-patterns]
"I'll use the Social Graph pattern..."

Or invoke directly: /insforge:postgres-schema-patterns

Contributing

We welcome contributions! Add new patterns by:

1. Create a new file in skills/postgres-schema-patterns/patterns/
2. Follow the existing pattern structure (Schema, RLS, SDK, Best Practices)
3. Submit a PR

Ideas for new patterns:

• E-commerce (orders, cart, inventory)
• Messaging (conversations, threads)
• Notifications
• Bookings & appointments
• Tags & categories

License

MIT