Search
Databases · SQL · By jeremylongshore
Skills
Sort:BestMost starsTrending todayTrending this weekTrending this monthNewestRecently updatedName
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | A skill your agent uses when you need to generate, validate, or deploy stored procedures for PostgreSQL, MySQL, or SQL Server. | jeremylongshore/ | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | yesterday |
| 2 | Process use when you need to work with database migrations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 3 | Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~1.7k | Automated safety check: Pass | MIT | yesterday |
| 4 | Scan a source tree for SQL-injection vulnerable patterns: string concatenation into queries, f-string interpolation in SQL, string-format substitution into raw queries, deprecated cursor methods… | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 5 | Review and safely diagnose Snowflake infrastructure and database deployments across the snowflakedb/snowflake Terraform 2.x provider, grants/state/imports, schemachange versioned and repeatable… | jeremylongshore/ | 2.8k | — | ~3.9k | Automated safety check: Pass | MIT | yesterday |
| 6 | Audit, analyze, and diagnose completed or failed Snowflake queries from query history, Query Insights, and GETQUERYOPERATORSTATS evidence. | jeremylongshore/ | 2.8k | — | ~4.3k | Automated safety check: Pass | MIT | yesterday |
| 7 | Insert, query, and aggregate data in ClickHouse with real SQL patterns. | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 8 | Handle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL. | jeremylongshore/ | 2.8k | — | ~1.5k | Automated safety check: Pass | MIT | yesterday |
| 9 | Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management. | jeremylongshore/ | 2.8k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 10 | Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and zero-downtime schema changes. | jeremylongshore/ | 2.8k | — | ~1.4k | Automated safety check: Pass | MIT | yesterday |
| 11 | Secure ClickHouse with user management, network restrictions, TLS, and audit logging. | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 12 | 12.Data Analyst Data exploration and analysis partner for Product Managers. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~2.7k | Automated safety check: Pass | MIT | yesterday |
| 13 | Deep Supabase diagnostics: pgstatstatements for slow queries, lock debugging with pglocks, connection leak detection, RLS policy conflicts, Edge Function cold starts, and Realtime connection drop… | jeremylongshore/ | 2.8k | — | ~2.8k | Automated safety check: Pass | MIT | yesterday |
| 14 | Configure cloud sql instance setup operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~567 | Automated safety check: Pass | MIT | yesterday |
| 15 | A skill your agent uses when working with structured data files (CSV, JSON, YAML, TOML, Parquet) — querying, transforming, filtering, aggregating, or converting between formats | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 16 | 16.Flux Migrate Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence. | jeremylongshore/ | 2.8k | — | ~1.9k | Automated safety check: Notes | MIT | yesterday |
| 17 | 17.Flux Query Optimize slow database queries — analyze execution plans, add indexes, rewrite queries. | jeremylongshore/ | 2.8k | — | ~810 | Automated safety check: Notes | MIT | yesterday |
| 18 | Wire GA4 → BigQuery for unsampled, queryable event-level data. | jeremylongshore/ | 2.8k | — | ~2.8k | Automated safety check: Pass | MIT | yesterday |
| 19 | Design and spec an analytical dashboard — define the question each chart answers, write the SQL queries, spec the layout and refresh cadence. | jeremylongshore/ | 2.8k | — | ~2.3k | Automated safety check: Notes | MIT | yesterday |
| 20 | 20.Lens Metrics Produce a complete metrics definition doc — metric name, formula, data source, segmentation, SQL or event tracking spec, and what good/bad looks like. | jeremylongshore/ | 2.8k | — | ~2.8k | Automated safety check: Notes | MIT | yesterday |
| 21 | 21.Lens Recon Analytics reconnaissance for takeover — find all analytics tools, inventory what's tracked and dashboarded, assess data freshness and metric definitions, and present a coverage map. | jeremylongshore/ | 2.8k | — | ~1.2k | Automated safety check: Notes | MIT | yesterday |
| 22 | 22.Lens Report Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison. | jeremylongshore/ | 2.8k | — | ~1.3k | Automated safety check: Notes | MIT | yesterday |
| 23 | Generate sql migration generator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~580 | Automated safety check: Pass | MIT | yesterday |
| 24 | Optimize sql query optimizer operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~561 | Automated safety check: Pass | MIT | yesterday |
| 25 | Assist with sql transform helper operations. An agent skill from jeremylongshore/tons-of-skills-marketplace. | jeremylongshore/ | 2.8k | — | ~565 | Automated safety check: Pass | MIT | yesterday |
