Skill UI

A comprehensive guide to ensuring robust state management for LangGraph agents. This skill addresses common checkpointing pitfalls (like missing thread_id or non-JSON serializable state) and details best practices for implementing reliable state persistence using MemorySaver or PostgresSaver. It covers thread discipline, schema migration, and time-travel debugging for production-ready applications.

A comprehensive guide to advanced SQL injection (SQLi) methodologies for offensive security assessments and bug bounty hunting. Covers all major injection types, including error-based, boolean/time-based blind, out-of-band, and second-order injection. Provides specific payloads and techniques for MySQL, MSSQL, PostgreSQL, Oracle, and NoSQL databases, along with methods for bypassing WAFs, exploiting GraphQL, WebSocket, and modern API filters. Includes full automation workflows using tools like sqlmap.

A comprehensive and advanced playbook for mastering SQL injection techniques. It covers critical areas including WAF bypass, out-of-band data exfiltration, second-order injection, and exploitation strategies across major database systems (MySQL, MSSQL, Oracle, PostgreSQL). Essential for professional penetration testing and security auditing.

This skill is a comprehensive tool for managing and understanding SQL queries. It can explain complex SQL in plain English for non-technical stakeholders, optimize slow queries by identifying performance bottlenecks, generate functional SQL code from natural language prompts, and produce detailed query documentation and data dictionaries. Supports major dialects including PostgreSQL, MySQL, and BigQuery.

This skill guides the implementation of dynamic secrets using HashiCorp Vault. It focuses on generating short-lived, ephemeral credentials for services like databases (PostgreSQL, MySQL), AWS IAM, and PKI certificates. By automating credential generation, lease management, and rotation, it eliminates the risk associated with storing long-lived static secrets, ensuring compliance with zero-trust security models (PCI-DSS, NIST).

Neon Object Storage provides S3-compatible, branch-aware object storage directly integrated with your Neon Postgres project. It ensures that files (images, documents, user uploads) remain perfectly synchronized with the database schema across all development branches (dev, preview, staging, production). Use this skill when you need a single backend for both database rows and file assets, eliminating the need for separate cloud storage providers.

This skill provides comprehensive guidance on choosing and creating the appropriate Neon Postgres branch for development and testing workflows. Users must decide between a 'Normal' branch (for realistic migration testing with live data) or a 'Schema-Only' branch (for highly sensitive data environments). It details the decision rules, tool selection (CLI/MCP), and procedures for branch creation and resetting.

A comprehensive skill to diagnose and fix excessive Postgres egress (network data transfer) that leads to high cloud database bills. It guides the user through using `pg_stat_statements` to identify the most data-intensive queries. Key fixes include limiting selected columns (avoiding SELECT *), implementing pagination (LIMIT/OFFSET), and identifying high-frequency data sources for caching.

This comprehensive guide serves as a detailed reference for psql, the feature-rich interactive terminal for PostgreSQL. It covers connection methods (CLI flags, environment variables, ~/.pgpass), executing SQL queries, inspecting database objects using commands like \d, and managing data operations such as importing and exporting.

A comprehensive guide to safe and reversible database migration patterns. Covers zero-downtime schema changes, data backfilling, and rollbacks for major databases like PostgreSQL and MySQL, and popular ORMs (Prisma, Drizzle, Django). Learn techniques like concurrent indexing and the expand-contract pattern to ensure production stability.

A comprehensive guide to PostgreSQL best practices, covering advanced indexing (GIN, BRIN, Partial), schema design, performance tuning, and security implementation (RLS). It details optimizing common SQL patterns like cursor pagination and UPSERT, essential for building high-performance, reliable database systems.

This comprehensive guide teaches researchers how to conduct an exhaustive "reinvention audit" for academic papers, specifically in the database field. It covers searching deep historical literature (pre-2000), modern conference venues (SIGMOD, ICDE), and industrial open-source systems (PostgreSQL, RocksDB) to ensure true novelty and properly position the contribution delta.