Topic · Databases
Best SQL skills, page 11
SQL skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 481 | Diagnose and optimize existing slow SQL queries using execution plans, indexing strategies, query rewriting, and ORM tuning. | seb1n/ | 206 | — | ~2.6k | Automated safety check: Pass | MIT | 1 mo ago |
| 482 | Generate SQL queries from natural-language requirements using SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries. | seb1n/ | 206 | — | ~2.3k | Automated safety check: Pass | MIT | 1 mo ago |
| 483 | Query and download NCI Imaging Data Commons (IDC) cancer radiology and pathology datasets via the idc-index Python client. | majiayu000/ | 666 | 1 repo | ~4.7k | Automated safety check: Pass | MIT | today |
| 484 | 智数分析专家团的核心分析引擎技能,提供数据源连接、查询执行、分析工作流编排和安全沙盒执行的完整能力框架. An agent skill from infometa/workbuddyskills. | infometa/ | 344 | — | ~855 | Automated safety check: Pass | No licence | today |
| 485 | 485.Tanyuan Search 腾讯探元文博检索工具集(Agentic RAG)。封装两个 HTTP API 为 Node.js 脚本,由 Agent 依据问题特征选择工具并构造 query: - search-relics(文物/世界遗产数据库 NL→SQL):适合结构化事实的详情、列表、统计与排行查询 -… | infometa/ | 344 | — | ~1.2k | Automated safety check: Pass | No licence | today |
| 486 | 486.SQL Idioms SQL coding standards: CTEs, explicit JOINs, index optimization, query execution plan analysis, transaction locking, and zero-downtime migration patterns. | irahardianto/ | 157 | — | ~1.5k | Automated safety check: Pass | MIT | 3 days ago |
| 487 | 487.Database Hana Apply SAP HANA database standards for SQL parameterization, in-memory engine optimization, dynamic IN query chunking, column aliasing on joins, and datatype casting. | HoangNguyen0403/ | 571 | — | ~920 | Automated safety check: Pass | MIT | today |
| 488 | 488.Golang Database Implement Go database access with context, pool tuning, transaction boundaries, and repository seams. | HoangNguyen0403/ | 571 | — | ~824 | Automated safety check: Pass | MIT | today |
| 489 | Migrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. | boshi-xixixi/ | 275 | — | ~576 | Automated safety check: Pass | MIT | 4 mo ago |
| 490 | Mass spectrometry (MS) data backend supporting import and export of MS/MS library spectra from MassBank record files. | bioMate-AI/ | 804 | — | ~1k | Automated safety check: Pass | Unknown | 3 mo ago |
| 491 | A skill your agent uses when 需要按 Alibaba Java Coding Guidelines(阿里巴巴 Java 编码规范)审查、生成或重构 Java、Spring、MyBatis、Maven、MySQL、SQL、日志、异常、安全或数据库相关代码。 | aiskillstore/ | 430 | — | ~503 | Automated safety check: Pass | Apache-2.0 | today |
| 492 | 492.Dbcraft Open and operate the local DB Craft visual schema studio at D:\DBdesigner. | aiskillstore/ | 430 | — | ~2.3k | Automated safety check: Pass | No licence | today |
| 493 | 493.SQL Expert Write, optimize, and debug T-SQL queries for Microsoft SQL Server. | aiskillstore/ | 430 | — | ~720 | Automated safety check: Pass | No licence | today |
| 494 | Writes and executes SQL queries against the data warehouse using dbt's Semantic Layer or ad-hoc SQL to answer business questions. | Kilo-Org/ | 190 | — | ~1.9k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 495 | 495.Oracle Database Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. | Kilo-Org/ | 190 | — | ~1.1k | Automated safety check: Pass | Unknown | 9 days ago |
| 496 | 496.Oracledb Use these skills to manage and monitor Oracle databases by executing SQL statements, exploring schema metadata, analyzing query performance, monitoring active sessions and resource consumption, and… | Kilo-Org/ | 190 | — | ~782 | Automated safety check: Notes | Apache-2.0 | 9 days ago |
| 497 | 497.Udf Benchmark Assists with benchmarking and profiling the performance of an Apache Spark UDF on the GPU. | Kilo-Org/ | 190 | — | ~802 | Automated safety check: Pass | Proprietary | 9 days ago |
| 498 | 498.Pyspark Etl Best practices for building performant, testable PySpark ETL pipelines with Spark SQL and Apache Iceberg. | Mindrally/ | 268 | — | ~2.4k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 499 | Reference for Snowflake Cortex AI Functions (AICOMPLETE, AICLASSIFY, AIEXTRACT, AIFILTER, etc.) and Cortex Search for building RAG applications entirely inside Snowflake. | Mindrally/ | 268 | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 500 | Best practices for Snowflake SQL, semi-structured data, and data pipelines built with Dynamic Tables, Streams, Tasks, and Snowpipe. | Mindrally/ | 268 | — | ~2.3k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 501 | Expert knowledge for Azure Elastic SAN development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations… | MicrosoftDocs/ | 777 | — | ~2k | Automated safety check: Pass | CC-BY-4.0 | 2 days ago |
| 502 | SQL and NoSQL query optimization techniques, indexing strategies, execution plan analysis, JOIN algorithms, cardinality estimation, and database-specific query patterns | nWave-ai/ | 617 | — | ~1.3k | Automated safety check: Pass | MIT | 21 days ago |