Best database skills, page 37

Backend infrastructure for a project via Cohesivity (cohesivity.ai).

Anil-matcha/awesome-muse-connectors

Control Ecovacs DEEBOT robot vacuums through the Ecovacs Open Platform: device list, status, battery, cleaning start/pause/stop, dock return.

Anil-matcha/awesome-muse-connectors

Inspect Neon serverless Postgres: projects, branches, databases.

Anil-matcha/awesome-muse-connectors

Read and write a Supabase Postgres database over PostgREST: list tables, query, insert, update, and delete rows.

Anil-matcha/awesome-muse-connectors

Read and write Upstash: get, set, and delete Redis keys, run command pipelines.

Anil-matcha/awesome-muse-connectors

Map claims in a literature to independent replications, robustness checks, failures, and unresolved evidence gaps.

flonat/flonat-research

Анализ журнала регистрации и технологического журнала 1С. An agent skill from IngvarConsulting/unica.

IngvarConsulting/unica

Оптимизация запросов 1С и СКД. An agent skill from IngvarConsulting/unica.

IngvarConsulting/unica

Connect to MySQL and run read-only queries to inspect table data.

hashgraph-online/awesome-codex-plugins

提供数据库设计、优化、数据工程和数据分析能力。当需要处理数据库操作、数据管道或数据分析时使用. An agent skill from Prorise-cool/Claude-Code-Multi-Agent.

Prorise-cool/Claude-Code-Multi-Agent

Use when the user prompts "repro".

romeerez/orchid-orm

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

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