Skill UI

This skill analyzes your data warehouse to pinpoint stale, unused, or redundant tables that contribute to unnecessary storage costs. It classifies waste patterns (e.g., Zombie, Temporary) and computes safety tiers, helping users understand which assets can safely be dropped or archived to optimize spending and improve data governance.

This advanced skill performs code review by simulating the documented engineering philosophies of historical figures (e.g., Linus Torvalds, Steve Jobs, Ken Thompson). It moves beyond generic AI findings by grounding critiques in specific, citable principles—such as 'good taste' or 'customer experience.' Ideal for high-stakes PRs, architectural reviews, and ensuring deep, pre-submission code hardening.

The Neon AI Gateway provides a single API endpoint and one credential to access a diverse catalog of frontier and open-source LLMs (including OpenAI, Anthropic, Google Gemini, Meta, Alibaba, and DeepSeek). This unified layer simplifies integration by eliminating the need for separate provider accounts and managing model-specific SDK complexities. It allows developers to switch between models seamlessly by changing only the model name, while also providing crucial branch-scoped isolation for development and CI environments.

Neon Functions provide long-running, stateful, serverless HTTP handlers deployed directly next to your Neon database branch. They are ideal for complex backend workloads that exceed traditional serverless limits, such as real-time WebSockets, Server-Sent Events (SSE) streaming, or sophisticated AI agents. Functions automatically inject the database connection URL and maintain state within the function scope, ensuring high performance and data proximity.

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.

Generate comprehensive, ready-to-use CI/CD pipeline configurations for running automated API tests using Newman. This skill provides templates for major platforms like GitHub Actions, GitLab CI, Jenkins, and Azure DevOps. It ensures seamless integration of Postman collections into automated build processes, including setting up environment variables, running tests, and publishing detailed JUnit and HTML reports.

This skill is designed for complex, multi-step tasks requiring coordination among multiple AI agents. It implements a robust workflow engine that first generates a detailed plan (task graph, topology) and then orchestrates parallel execution with adversarial verification. Use this when the task spans many files, requires multiple specialized roles, or involves an overall 'workflow' concept, ensuring structured, reliable, and auditable results.

Provides a comprehensive guide for authentically marketing and growing open source projects. Covers best practices for GitHub optimization (README, repository setup), community building, and implementing sustainable growth strategies, ensuring the project is discoverable and valuable.

A robust protocol designed for multi-agent collaboration on long-running projects. It simulates a self-optimizing city where diverse AI agents (citizens) interact using decentralized markdown files (The Register, Contracts, Chronicle). This framework enables cross-vendor optimization, dynamic work routing, and constitutional evolution without requiring a centralized server or specific runtime environment.

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.