Databases · By jeremylongshore

Run ClickHouse locally with Docker, configure test fixtures, and iterate fast.

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

Configure ClickHouse across dev, staging, and production with environment-specific settings, secrets management, and infrastructure-as-code patterns.

jeremylongshore/tons-of-skills-marketplace

Monitor ClickHouse with Prometheus metrics, Grafana dashboards, system table queries, and alerting for query performance, merge health, and resource usage.

jeremylongshore/tons-of-skills-marketplace

Optimize ClickHouse query performance with indexing, projections, settings tuning, and query analysis using system tables.

jeremylongshore/tons-of-skills-marketplace

Production readiness checklist for ClickHouse — server tuning, backup, monitoring, and deployment verification.

jeremylongshore/tons-of-skills-marketplace

Configure ClickHouse query concurrency, memory quotas, and connection limits.

jeremylongshore/tons-of-skills-marketplace

Production reference architecture for ClickHouse-backed applications — project layout, data flow, multi-tenant patterns, and operational topology.

jeremylongshore/tons-of-skills-marketplace

Production-ready patterns for @clickhouse/client — streaming inserts, typed queries, error handling, and connection management.

jeremylongshore/tons-of-skills-marketplace

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

jeremylongshore/tons-of-skills-marketplace

A skill your agent uses when upgrading ClickHouse server versions or the @clickhouse/client SDK, handling breaking changes between versions, or migrating from older client libraries — covers version…

jeremylongshore/tons-of-skills-marketplace

Ingest data into ClickHouse from webhooks, Kafka, and streaming sources with batching, dedup, and exactly-once patterns.

jeremylongshore/tons-of-skills-marketplace

Optimize Customer.io API performance for high throughput. An agent skill from jeremylongshore/tons-of-skills-marketplace.

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

Best practices for handling Evernote data. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Design Fly.io Managed Postgres, Fly Volumes, and private 6PN connectivity with explicit durability boundaries.

jeremylongshore/tons-of-skills-marketplace

Migrate Fly.io app configuration, runtime images, Machine resources, regions, volumes, or Managed Postgres through staged change control.

jeremylongshore/tons-of-skills-marketplace

Manage the freshie ecosystem inventory database — a CMDB tracking all plugins, skills, packs, and compliance grades across 51 SQLite tables.

jeremylongshore/tons-of-skills-marketplace

Optimize Kling AI for speed, quality, and cost efficiency. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Implement intelligent API response caching with Redis, Memcached, and CDN integration.

jeremylongshore/tons-of-skills-marketplace

Implement API migrations between versions, platforms, or frameworks with minimal downtime.

jeremylongshore/tons-of-skills-marketplace

Design and execute a reversible Notion content or schema migration with identity maps, checkpoints, and reconciliation.

jeremylongshore/tons-of-skills-marketplace

Migrate to OCI Autonomous Database — wallet setup, mTLS, Data Pump, and python-oracledb.

jeremylongshore/tons-of-skills-marketplace

Autonomous app builder that converts plain-English descriptions into fully built, tested applications.

jeremylongshore/tons-of-skills-marketplace

Implement Shopify app reference architecture with Remix, Prisma session storage, and the official app template patterns.

jeremylongshore/tons-of-skills-marketplace

Optimize Speak API latency with audio preprocessing, response caching, and connection pooling.

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

Diagnose and fix Supabase errors across PostgREST, PostgreSQL, Auth, Storage, and Realtime.

jeremylongshore/tons-of-skills-marketplace

Optimize Supabase costs through plan selection, database tuning, storage cleanup, connection pooling, and Edge Function optimization.

jeremylongshore/tons-of-skills-marketplace

A skill your agent uses when reviewing Supabase code, onboarding developers, auditing an existing project, or debugging unexpected behavior — catches the twelve most common Supabase mistakes…

jeremylongshore/tons-of-skills-marketplace

A skill your agent uses when preparing a Supabase project for production load — traffic spikes, connection-limit tuning, read replicas for analytics queries, CDN caching for Storage, regional Edge…

jeremylongshore/tons-of-skills-marketplace

Database migration patterns with the Supabase CLI: npx supabase migration new, zero-downtime migrations, data backfill strategies, schema versioning, rollback strategies, and TypeScript type…

jeremylongshore/tons-of-skills-marketplace

Optimize Supabase query performance with indexes, EXPLAIN ANALYZE, connection pooling, column selection, pagination, RPC functions, materialized views, and diagnostics.

jeremylongshore/tons-of-skills-marketplace

Execute a Supabase production deployment checklist covering RLS, key hygiene, connection pooling, backups, monitoring, Edge Functions, and Storage policies.

jeremylongshore/tons-of-skills-marketplace

Design Supabase Postgres schema from business requirements with migrations, RLS, and types.

jeremylongshore/tons-of-skills-marketplace

Encapsulate Together AI SDK v2 behind a typed adapter with catalog-resolved models, bounded retries, streaming normalization, usage capture, and OpenAI-compatible migration seams.

jeremylongshore/tons-of-skills-marketplace

Process data normalization tool operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Build filtering query builder operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Migrate between AppFolio API versions and handle endpoint changes.

jeremylongshore/tons-of-skills-marketplace

Export and convert Apple Notes to Markdown, JSON, HTML, and SQLite.

jeremylongshore/tons-of-skills-marketplace

Create bigquery ml model creator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Manage bigquery scheduled query operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Create bigquery table creator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Generate bigquery view generator operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

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

Configure connection pooling config operations. An agent skill from jeremylongshore/tons-of-skills-marketplace.

jeremylongshore/tons-of-skills-marketplace

Build cte query builder 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