Search Results: sql-optimization

Found 51 Skills

Backend Developmentadityawrk/analytics-with-...

sql-optimizer

Analyze and optimize slow SQL queries. Use when the user says a query is slow, asks to optimize or speed up SQL, wants to find anti-patterns, needs index recommendations, or asks for a query rewrite. Also use when EXPLAIN output shows full table scans or poor join strategies.

🇺🇸|EnglishTranslated

Data Processingtimescale/pg-aiguide

design-postgis-tables

Comprehensive PostGIS spatial table design reference covering geometry types, coordinate systems, spatial indexing, and performance patterns for location-based applications

🇺🇸|EnglishTranslated

Backend Developmentsidetoolco/org-charts

database-optimizer

Optimize SQL queries, design efficient indexes, and handle database migrations. Solves N+1 problems, slow queries, and implements caching. Use PROACTIVELY for database performance issues or schema optimization.

🇺🇸|EnglishTranslated