Does it provide best practices for database security?

Yes, it includes guidance on secure schema design, role-based access control, and preventing SQL injection through prepared statements.

Can this skill help with PostgreSQL-specific data types?

Yes, it offers deep support for advanced types like JSONB, arrays, HSTORE, and geometric types, including guidance on how to query them efficiently.

Is this skill useful for database migrations?

Absolutely. It can help translate SQL dialects from other systems (like MySQL or SQL Server) into PostgreSQL-compliant syntax and optimized patterns.

How does the PostgreSQL skill improve my SQL queries?

The skill provides specific advice on rewriting queries, suggesting the best indexing strategies, and interpreting EXPLAIN ANALYZE results to reduce latency.

PostgreSQL Database Expert

Name: PostgreSQL Database Expert
Author: partme-ai

bypartme-ai

•

データベース管理

Optimizes PostgreSQL workflows by providing expert guidance on SQL syntax, performance tuning, and advanced data features.

概要

This skill transforms Claude into a PostgreSQL specialist, offering deep expertise in schema design, complex query optimization, and advanced features like JSONB support and full-text search. It is ideal for developers needing to migrate data, write high-performance SQL, or implement sophisticated database logic while ensuring adherence to industry-standard best practices and performance metrics. Whether you are building a new application or refactoring a legacy system, this skill provides the domain-specific knowledge required to leverage the full power of the PostgreSQL engine.

主な機能

Comprehensive support for JSONB and unstructured data management
Guidance on stored procedures, triggers, and custom PostgreSQL functions
37 GitHub stars
Advanced SQL query optimization and execution plan analysis
Implementation patterns for full-text search and specialized indexing
Expert schema design, normalization, and migration strategies

ユースケース

Designing scalable relational schemas for complex application data
Refactoring slow-running legacy queries for better performance
Implementing advanced search and JSON-based storage solutions

概要

主な機能

Comprehensive support for JSONB and unstructured data management
Guidance on stored procedures, triggers, and custom PostgreSQL functions
37 GitHub stars
Advanced SQL query optimization and execution plan analysis
Implementation patterns for full-text search and specialized indexing
Expert schema design, normalization, and migration strategies

ユースケース

Designing scalable relational schemas for complex application data
Refactoring slow-running legacy queries for better performance
Implementing advanced search and JSON-based storage solutions