Skill UI

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.

Pi-hole is a powerful, network-wide DNS ad blocker that runs on Linux hosts (like Raspberry Pi). It intercepts all DNS queries on your local network, blocking advertisements, trackers, and known malware domains before they reach your devices. This guide covers setup via Docker or bare metal, configuring network DNS, managing blocklists, and enabling secure DNS-over-HTTPS (DoH) for enhanced privacy.

A comprehensive guide to building robust database layers in Kotlin using the Exposed ORM framework. It covers advanced patterns including DSL queries, DAO entity management, transaction handling, connection pooling with HikariCP, schema migration via Flyway, and implementing the Repository pattern for clean, production-grade data access.

A comprehensive guide covering advanced patterns, common pitfalls, and optimization techniques for using Prisma ORM in TypeScript backend applications. Learn best practices for schema design, handling transactions, optimizing queries (include vs select), and managing connection pools in production environments.