{"skill":{"slug":"sql-index-optimizer-multi-db","displayName":"当用户希望“通过建表语句 + 慢 SQL 自动优化索引”时使用此 Skill，支持 MySQL、Oracle、PostgreSQL。脚本使用 Python，自动解析 DDL 与慢 SQL 中的 WHERE/JOIN/ORDER BY 列，生成候选索引及对应数据库的 CREATE INDEX 语句，并输出到文件。","summary":"当用户希望“通过建表语句 + 慢 SQL 自动优化索引”时使用此 Skill，支持 MySQL、Oracle、PostgreSQL。脚本使用 Python，自动解析 DDL 与慢 SQL 中的 WHERE/JOIN/ORDER BY 列，生成候选索引及对应数据库的 CREATE INDEX 语句，并输出到文件。","tags":{"latest":"1.0.0"},"stats":{"comments":0,"downloads":97,"installsAllTime":0,"installsCurrent":0,"stars":0,"versions":1},"createdAt":1775532585242,"updatedAt":1775532708920},"latestVersion":{"version":"1.0.0","createdAt":1775532585242,"changelog":"Initial release for automated SQL index optimization on MySQL, Oracle, and PostgreSQL.\n\n- Parses table DDL and slow SQL statements to suggest candidate indexes.\n- Generates CREATE INDEX statements tailored to the target database.\n- Outputs results to markdown or JSON file, including reasons and statistics.\n- Supports prioritizing composite indexes and avoids redundant suggestions.\n- Provides guidance for final verification and notes on index impact.","license":"MIT-0"},"metadata":null,"owner":{"handle":"houyalei","userId":"s17ag52d73jtm6bc6hp0tv0pa984d0qt","displayName":"houyalei","image":"https://avatars.githubusercontent.com/u/25092614?v=4"},"moderation":null}