skills.rest
fromej-dev
fromej-devOFFICIAL
Explore all skills by this author →
WebsiteGitHub

postgres-patterns

A P2P lending platform where users can borrow and lend directly, without intermediaries. It leverages blockchain smart contracts and optionally integrates with decentralized storage and AI-powered credit scoring for automated, trustless loan management and disbursement, plus optional yield generation for lenders. It also includes a gamified onboarding experiencebaht featuring cute NFTsbfs, which u

Updated Aug 21, 2025
Search Tags:#query optimization#security#indexing#schema design#postgresql#rls#row level security
One-click install
npx skills add https://github.com/fromej-dev/excludr --skill postgres-patterns-fromej-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-patterns
Source: https://github.com/fromej-dev/excludr/tree/main/.claude/skills/postgres-patterns
Command: npx skills add https://github.com/fromej-dev/excludr --skill postgres-patterns-fromej-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL patterns that guide query optimization, schema design, indexing, and security, helping teams implement proven DB practices quickly and reliably.

Core Features & Use Cases

  • Pattern Catalog: common indexing strategies, query optimization techniques, and data modeling guidelines tailored for PostgreSQL.
  • Performance & Security: guidance on RLs, constraints, and access controls to enforce secure, high-performance deployments.
  • Use Case Scenarios: design a new schema, optimize complex queries, or migrate from other databases while aligning with best practices.

Quick Start

Analyze a provided PostgreSQL workload or schema and propose a concrete set of indexing and optimization patterns you would apply. For example, review a customers-orders-invoices schema and suggest suitable indexes, partitioning, and RLs based on typical query patterns.

Frequently Asked Questions about postgres-patterns

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries for a large database?▼

To optimize slow PostgreSQL queries, apply established indexing strategies and query optimization techniques like adding suitable indexes, implementing partitioning, and restructuring queries based on typical workload patterns to improve performance.

What is row level security and how does it control access in PostgreSQL?▼

Row level security (RLS) in PostgreSQL is an access control mechanism that restricts data access at the row level. It enforces secure deployments by ensuring users only query and modify rows they are explicitly permitted to access.

How do I design a PostgreSQL schema for a new application?▼

Designing a PostgreSQL schema involves applying data modeling guidelines and constraints to structure tables effectively. Using established schema design patterns ensures data integrity and aligns with high-performance query requirements.

Can I use these PostgreSQL patterns when migrating from another database?▼

Yes, you can use these PostgreSQL patterns when migrating from other databases. They provide data modeling guidelines and indexing strategies that help align your migrated schema and queries with PostgreSQL best practices for performance and security.

What's the best way to implement indexing and RLS for a customers-orders-invoices schema?▼

The best way to implement indexing and RLS for a customers-orders-invoices schema is to analyze typical query patterns and propose concrete indexing strategies, partitioning, and row level security rules based on established PostgreSQL best practices.

Related Skills

Explore More Software Engineering Skills→
JetBrainsJetBrains
302

supabase-postgres-best-practices

Identify and optimize PostgreSQL bottlenecks in schemas, queries, and configuration.

Official
Advanced
shygolyshygoly

postgres-patterns

Apply indexing, partitioning, and query-pattern techniques for PostgreSQL optimization.

Community
Intermediate
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
manutejmanutej
61

PostgreSQL Database Administration

Automate PostgreSQL administration for customer support platform databases.

Community
Advanced