SQL · By jeremylongshore

Detect and analyze SQL injection vulnerabilities in application code and database queries.

jeremylongshore/tons-of-skills-marketplace

A skill your agent uses when you need to generate, validate, or deploy stored procedures for PostgreSQL, MySQL, or SQL Server.

jeremylongshore/tons-of-skills-marketplace

Process use when you need to work with database migrations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Execute use when you need to work with query optimization. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Hunt down Databricks cost leaks — wasted DBUs, idle clusters, oversized SQL warehouses, and untagged runaway spend — and produce a FinOps cost report.

jeremylongshore/tons-of-skills-marketplace

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/tons-of-skills-marketplace

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/tons-of-skills-marketplace

Audit, analyze, and diagnose completed or failed Snowflake queries from query history, Query Insights, and GETQUERYOPERATORSTATS evidence.

jeremylongshore/tons-of-skills-marketplace

Insert, query, and aggregate data in ClickHouse with real SQL patterns.

jeremylongshore/tons-of-skills-marketplace

Handle data lifecycle in ClickHouse — TTL expiration, data deletion (GDPR), column-level encryption, and audit logging with real ClickHouse SQL.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse enterprise RBAC — SQL-based users, roles, row policies, column-level grants, and quota management.

jeremylongshore/tons-of-skills-marketplace

Execute ClickHouse schema migrations — ALTER TABLE operations, data migration between engines, versioned migration runners, and zero-downtime schema changes.

jeremylongshore/tons-of-skills-marketplace

Secure ClickHouse with user management, network restrictions, TLS, and audit logging.

jeremylongshore/tons-of-skills-marketplace

Data exploration and analysis partner for Product Managers. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Adopt the current unified QuickNode SDK with explicit product clients, timeouts, environment configuration, and platform checks.

jeremylongshore/tons-of-skills-marketplace

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/tons-of-skills-marketplace

Implement GDPR/CCPA compliance with Supabase: RLS for data isolation, user deletion via auth.admin.deleteUser(), data export via SQL, PII column management, backup/restore workflows, and retention…

jeremylongshore/tons-of-skills-marketplace

Run your first Supabase query — insert a row and read it back.

jeremylongshore/tons-of-skills-marketplace

Configure cloud sql instance setup operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

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/tons-of-skills-marketplace

Generates production-ready code from file specifications such as CSV files, JSON schemas, SQL DDL, protobuf definitions, or requirements documents.

jeremylongshore/tons-of-skills-marketplace

Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence.

jeremylongshore/tons-of-skills-marketplace

Optimize slow database queries — analyze execution plans, add indexes, rewrite queries.

jeremylongshore/tons-of-skills-marketplace

Wire GA4 → BigQuery for unsampled, queryable event-level data.

jeremylongshore/tons-of-skills-marketplace

Diagnose and fix Hex common errors and exceptions. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Design and spec an analytical dashboard — define the question each chart answers, write the SQL queries, spec the layout and refresh cadence.

jeremylongshore/tons-of-skills-marketplace

Produce a complete metrics definition doc — metric name, formula, data source, segmentation, SQL or event tracking spec, and what good/bad looks like.

jeremylongshore/tons-of-skills-marketplace

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/tons-of-skills-marketplace

Build a reporting pipeline — scheduled reports with SQL queries, delivery via Slack or email, threshold alerts, and historical comparison.

jeremylongshore/tons-of-skills-marketplace

Detect sql injection detector operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Generate sql migration generator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Optimize sql query optimizer operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Assist with sql transform helper operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace