Skill UI

Assistant for PostgreSQL developers that highlights native features, advanced data types, performance tuning patterns, and extension usage to optimize queries, indexes, and analytics in PostgreSQL projects.

Scaffolds an empty xUnit integration test project targeting Oracle in .NET solutions, including a transaction-rollback base class and seed data manager. Use in Phase 3 before writing Oracle baseline tests for Oracle-to-PostgreSQL migration.

A universal assistant for conducting deep code reviews across major SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). It rigorously analyzes SQL code for critical vulnerabilities (like SQL injection), performance bottlenecks, maintainability issues, and adherence to industry best practices. Features include security audits, index optimization recommendations, query structure analysis, and schema design validation, ensuring robust and secure database development.

Cross-database SQL performance optimization assistant offering query tuning, indexing strategies, pagination, batch operations, and monitoring guidance for MySQL, PostgreSQL, SQL Server, Oracle, and other relational systems.

LaminDB is an open-source lineage-native lakehouse designed for biological datasets and models. It enables queryable, traceable, and validated data management across various storage formats like S3 and Postgres. Users can track computational workflows, curate data with ontologies via Bionty, and ensure FAIR compliance. Ideal for managing scRNA-seq, spatial transcriptomics, and integrating ML pipelines while maintaining reproducibility and collaboration.

This reference architecture provides a blueprint for integrating Fathom meeting intelligence data into enterprise systems. It details the full data pipeline, spanning from initial Fathom recordings via webhooks to structured storage (PostgreSQL), action item extraction, and downstream synchronization with CRMs (like Salesforce/HubSpot) and email systems. Ideal for developers building automated, real-time business process workflows.

Outlines a comprehensive, fast local development loop for applications hosted on Fly.io. It guides users through testing Docker containers locally, proxying remote services like Postgres and Redis to localhost, configuring dev environments, and performing fast deployment cycles. Essential for modern edge computing development.

Provides a comprehensive reference architecture for deploying highly scalable, low-latency applications on Fly.io. It details best practices for multi-region web tiers, achieving high availability with Postgres read replicas, implementing Redis caching, managing background workers, and securing connectivity via private internal networking for robust production systems.

Builds a robust, automated workflow to export critical sales data—including forecasts, quota details, adjustments, and CRM totals—from Clari CRM to a designated data warehouse. The pipeline supports multiple targets like Snowflake, BigQuery, and PostgreSQL, ensuring that real-time revenue intelligence is available for advanced analytics and business reporting.

This skill redirects deprecated requests to the canonical Aurora DSQL skill for managing distributed SQL schemas, migrations, queries, authentication, and performance. It supports application development on AWS Aurora databases. Users should follow the installation instructions in awslabs/agent-plugins for the verified plugin.

This skill guides users through setting up robust, production-grade infrastructure on Fly.io. It covers creating and connecting to Fly Postgres clusters for reliable data storage, provisioning persistent NVMe Volumes for durable file storage, and configuring private internal networking (6PN) for secure service-to-service communication. It is essential for modern microservices requiring stable databases and persistent state.

This comprehensive guide provides step-by-step instructions for migrating and upgrading services on the Fly.io platform. It details critical processes such as migrating applications from Apps v1 (Nomad) to v2 (Machines), upgrading the flyctl CLI, performing major Postgres database version upgrades, and executing region migrations. Essential for maintaining and modernizing cloud infrastructure.