Databases · jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

Analyze network latency and optimize request patterns for faster communication.

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

Automate database backup processes with scheduling, compression, and encryption.

jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

Process use when you need to work with database documentation.

jeremylongshore/tons-of-skills-marketplace

Process use when you need to work with database schema design.

jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

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

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 implement multi-tier caching to improve database performance.

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

Process use when you need to work with database partitioning.

jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

Process use when you need to work with database scalability.

jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

Test database testing including fixtures, transactions, and rollback management.

jeremylongshore/tons-of-skills-marketplace

Build use when you need to work with NoSQL data modeling. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Process use when you need to work with connection management.

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

Process use when you need to work with security and compliance.

jeremylongshore/tons-of-skills-marketplace

Guard production Databricks data pipelines — Delta Lake, Liquid Clustering, Structured Streaming, Auto Loader, and DLT — against the twelve foot-guns that fire at scale: OPTIMIZE/auto-compaction…

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

Deduplicate Podium contacts in production and survive the data-quality failures — phone-format inconsistency producing four contacts for one phone, merge-api ordering that silently discards the…

jeremylongshore/tons-of-skills-marketplace

Audit Snowflake effective access and produce a safe least-privilege change packet.

jeremylongshore/tons-of-skills-marketplace

Audit and analyze Snowflake warehouse, serverless, Adaptive, storage, transfer, and AI cost evidence with a typed ledger that prevents double counting and exposes freshness, attribution, control…

jeremylongshore/tons-of-skills-marketplace

Assess trusted Snowflake data metric function coverage and expectation evidence without reading customer rows.

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

Analyze Snowflake failover-group RPO/RTO readiness from independently trusted, privacy-preserving live receipts without executing refresh, failover, failback, redirect, cancellation, resume, or…

jeremylongshore/tons-of-skills-marketplace

Audit trusted Snowflake classification, tags, masking, row access, projection, join, aggregation, and privacy-policy evidence without reading customer data.

jeremylongshore/tons-of-skills-marketplace

Preflight Snowflake Native App package releases from trusted, privacy-safe provider evidence without publishing, upgrading, altering, granting, or approving anything.

jeremylongshore/tons-of-skills-marketplace

Analyze Snowflake pipelines spanning tasks, streams, dynamic tables, and Snowpipe from bounded read-only evidence.

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

Pilot a Snowflake authentication modernization without lockouts or credential exposure.

jeremylongshore/tons-of-skills-marketplace

Manage Apify datasets, key-value stores, and request queues programmatically, and orchestrate multi-Actor pipelines.

jeremylongshore/tons-of-skills-marketplace

Analyze and improve Attio integration latency and throughput from measured query shape, pagination, concurrency, retry, and cache evidence while preserving correctness.

jeremylongshore/tons-of-skills-marketplace

Run ClickHouse integration tests in CI with GitHub Actions and Docker containers.

jeremylongshore/tons-of-skills-marketplace

Diagnose and fix the top 15 ClickHouse errors — query failures, insert problems, memory limits, and merge issues.

jeremylongshore/tons-of-skills-marketplace

Design ClickHouse schemas with MergeTree engines, ORDER BY keys, and partitioning.

jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

Optimize ClickHouse Cloud costs — compute scaling, storage tiering, compression, and query efficiency for lower bills.

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

Collect ClickHouse diagnostic data — system tables, query logs, merge status, and server metrics for support tickets and troubleshooting.

jeremylongshore/tons-of-skills-marketplace

Deploy ClickHouse-backed applications to Vercel, Fly.io, and Cloud Run with connection pooling, secrets, and health checks.

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

Create your first ClickHouse table, insert data, and run analytical queries.

jeremylongshore/tons-of-skills-marketplace

ClickHouse incident response — triage, diagnose, and remediate server issues using system tables, kill stuck queries, and execute recovery procedures.

jeremylongshore/tons-of-skills-marketplace

Install @clickhouse/client and configure authentication to ClickHouse Cloud or self-hosted.

jeremylongshore/tons-of-skills-marketplace