Skill UI

A comprehensive guide to advanced development practices on the Snowflake platform. Covers best practices for SQL (MERGE, semi-structured data, colon prefix rule), modern data pipeline construction (Dynamic Tables, Streams/Tasks, Snowpipe), and deep integration with Cortex AI functions and Snowpark Python. Essential knowledge for data engineers building robust, scalable, and intelligent data applications.

A powerful operational companion for database developers. This skill assists with the daily lifecycle of database interactions, including translating natural language requirements into optimized SQL queries, generating database migrations, performing comprehensive schema introspection across multiple dialects (PostgreSQL, MySQL, SQLite, SQL Server), and identifying performance bottlenecks through detailed query optimization and index recommendations. It also supports ORM patterns like Prisma and SQLAlchemy.

This guide provides comprehensive patterns for designing and implementing secure multi-tenant SaaS applications using shared databases. It covers critical techniques like Row-Level Security (RLS) in PostgreSQL, implementing tenant-aware middleware in TypeScript (Express/Fastify), and enforcing data scoping at the ORM level (Prisma/Drizzle). Learn how to prevent data leakage and manage tenant isolation across shared schemas.

This skill provides a comprehensive guide and structured SQL templates for performing deep forensic investigations on AWS cloud logs. It utilizes AWS Athena to query massive datasets from CloudTrail, VPC Flow Logs, S3 access logs, and ALB logs. Ideal for detecting unauthorized access, data exfiltration, and privilege escalation during security incident response.

A guide for security researchers focused on finding exploitable, remote-reachable vulnerabilities for bug bounties or responsible disclosure. It emphasizes high-signal flaws such as SSRF, RCE, and SQL injection, while guiding users through the professional triage and PoC creation process for penetration testing.

Analyzes Excel and CSV uploads with DuckDB, inspecting schemas, running SQL, summarizing statistics, and exporting results so users can explore structured data efficiently.

A comprehensive guide detailing best practices for database interaction in Go. It covers secure query writing using parameterized placeholders, handling transactions, managing connection pooling, dealing with NULLable columns, and choosing between libraries like sqlx and pgx, while strongly advising against using ORMs.

Provides quick reference to penetration testing commands for network scanning, exploitation, password cracking, and web testing workflows, helping security professionals run tools like Nmap, Metasploit, Nikto, and SQLMap during assessments.

This guide provides a comprehensive, step-by-step process to scaffold a modern Spring Boot application using Kotlin. It covers downloading the template, configuring dependencies (including SpringDoc and ArchUnit), and setting up complex polyglot environments using Docker Compose. Supports PostgreSQL, MongoDB, Redis, and WebFlux reactive programming.

This comprehensive guide covers best practices for building robust database systems. It teaches crucial concepts like schema normalization, effective indexing strategies, selecting the right database (e.g., SQLite vs PostgreSQL) and ORM, and optimizing queries to prevent common performance issues like N+1 problems. It emphasizes making context-aware architectural decisions.

A comprehensive guide and workflow for identifying behavioral risks when migrating applications from Oracle to PostgreSQL. It cross-references code against known differences in complex areas such as empty strings, refcursors, type coercion, sorting, and concurrent transaction handling. Essential for both pre-migration architectural planning and post-migration validation testing.

Guides an AI pair to document application needs, access patterns, and scaling concerns while producing Azure Cosmos DB NoSQL requirements and data model artifacts using established best practices in a structured workflow.