Skill UI

This skill specializes in optimizing complex SQL queries, designing efficient database schemas, and diagnosing performance bottlenecks across various SQL dialects (PostgreSQL, MySQL, SQL Server, etc.). Use it when dealing with slow queries, complex data aggregation, advanced joins, or when needing to implement best practices like CTEs, window functions, and covering indexes. It provides deep analysis of execution plans (EXPLAIN/ANALYZE) to ensure peak data retrieval performance.

Diagnose and fix Odoo performance bottlenecks by tuning PostgreSQL queries, adjusting worker/memory limits, and applying profiling insights to achieve faster page loads and stable production behavior.

Guides Sankhya dashboard developers on HTML/JSP/Java patterns, SQL sanitization, BI parameterization, and UI/UX consistency so dashboards load reliably with lazy-loading states and structured queries.

polars-bio accelerates genomic interval math and bioinformatics I/O by combining Polars, Arrow, and DataFusion to handle BED/VCF/BAM/GFF/FASTA streams, SQL queries, and cloud storage with overlap, coverage, and nearest APIs plus streaming fallbacks.

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.

Practical guide for Go developers to write safe, observable database code with policy on parameterized queries, context propagation, error handling, transactions, isolation, connection pools, batching, and migration tooling for Postgres/MariaDB/MySQL/SQLite.

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.