Best database skills, page 26

Write or update the user-facing posthog.com documentation for a PostHog Data warehouse import source.

PostHog/posthog

Determine which PostHog team owns a file, directory, or code path, or enumerate all code a team owns (via distributed owners.yaml, products//product.yaml, and .github/CODEOWNERS).

PostHog/posthog

Explore and diagnose a PostHog endpoint's execution logs — error messages, failed runs, cache misses, slow runs, or unexpected row counts during endpoint invocations.

PostHog/posthog

Pick the right y-axis unit when creating or updating an insight via posthog:insight-create or posthog:insight-update — both TrendsQuery (trendsFilter.aggregationAxisFormat) and SQL insights…

PostHog/posthog

Implement and extend PostHog Data warehouse import sources. An agent skill from PostHog/posthog.

PostHog/posthog

Investigates a session recording by gathering metadata, person profile, same-session events, and linked error tracking issues in one pass.

PostHog/posthog

Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT).

PostHog/posthog

Runs read-only production database analysis through PostHog's internal Metabase instances.

PostHog/posthog

Query tophog — the ingestion pipeline's heavy-hitter store in ClickHouse — to identify hot or expensive actors (teamid, distinctid, sessionid, partition) during incident triage.

PostHog/posthog

A skill your agent uses when adding a bucket-like rate limit backed by Redis: a per-caller budget with burst capacity and continuous refill, a refund path for requests that did no work, or a limit…

PostHog/posthog

Provision and operate Supabase Postgres for this project — creating the project, picking the right connection string for each job, local CLI workflow, migrations, generated types, RLS policies, and…

textura-agency/next16-claude-starter

A skill your agent uses when syncing real-time data, structuring JSON trees, reading/writing, creating listeners, enabling offline persistence, managing presence, sharding, or writing security rules.

evanca/flutter-ai-rules

标准 SOP：集群巡检 checkcluster/checklist 与 RCA 入口（rcarun/rcalist）。用户要健康检查、巡检时使用；RCA 场景映射与手动降级详见 obdiag-rca skill；与 observer-log-analysis、observer-sql-analysis、obproxy-log-analysis 分工明确。

oceanbase/obdiag

A skill your agent uses when writing code that runs concurrently in ChatbotX — BullMQ worker consumers, sharded DB migrations, embedding replace-writes, or any multi-step operation that could be…

ChatbotXIO/ChatbotX

当需要获取 funboost 任务的执行返回值时使用。触发场景：实现请求-响应模式、使用 AsyncResult/AioAsyncResult 获取函数返回值、查询任务状态和结果。关键词：RPC, task result, AsyncResult, AioAsyncResult, isusingrpcmode, 获取任务结果, 返回值。

ydf0509/funboost

当需要用 funboost 进行 Web 爬虫或数据采集时使用。触发场景：分布式爬虫、URL 调度、funspider、boostspider、httpx 爬虫。关键词：爬虫, spider, crawl, funspider, SimpleSpiderClient, AsyncSpiderClient, URL 调度, 分布式采集。

ydf0509/funboost

当需要使用 funboost 创建定时/周期性任务时使用。触发场景：cron 定时调度、interval 间隔执行、ApsJobAdder 定时发布消息、APScheduler 集成。关键词：ApsJobAdder, timing, schedule, cron, interval, 定时任务, apscheduler, addpushjob, 周期执行。

ydf0509/funboost

当需要编排多个 funboost 任务按顺序或并行执行时使用。触发场景：chain 串行流水线、group 并行执行、chord 扇出聚合、嵌套 chain/group/chord 组合、任务依赖编排。关键词：workflow, chain, group, chord, pipeline, 嵌套组合, 工作流, 任务依赖, fan-out, fan-in…

ydf0509/funboost

当需要使用 funboost 编写分布式任务时使用。触发场景：创建 @boost 装饰器任务函数、使用 push/publish 发布消息、启动 consume 消费者、配置 BoosterParams 参数、设置并发和限流。关键词：boost, BoosterParams, queuename, push, publish, consume, distributed task, 分布式任务…

ydf0509/funboost

Delegate one rpi-cluster chaos iteration and summarize integrity and replication metrics during data-loss or failover investigations.

celeriant/celeriant-db

Implement or debug FiveM SQL using oxmysql, including bound parameters, result shapes, schema changes and transaction semantics.

sky-systems/sky_phone

Guide for implementing Better Auth - a framework-agnostic authentication and authorization framework for TypeScript.

einverne/dotfiles

Patterns for SQLite databases in Python projects - state management, caching, and async operations.

aiskillstore/marketplace

Change eXeLearning asset paths, sharding, cache persistence, chunked imports, save/export file handling or cleanup.

exelearning/exelearning

Multi-route literature expansion + metadata normalization for evidence-first surveys.

WILLOSCAR/research-units-pipeline-skills

Normalizes asset filenames by splitting on common separators, stripping asset IDs and optional user strings from each segment, then joining with underscores (snakecase).

godot-fun/gai

AgentDB memory system with HNSW vector search. An agent skill from ruvnet/ruflo.

ruvnet/ruflo

Classifies a diff into file tags and hunk tags - new public export, new endpoint, modified auth, SQL string, migration, added dependency, touched prompt - then maps each tag to the quality practices…

jaktestowac/awesome-copilot-for-testers

Strategic guidance for designing modern data platforms, covering storage paradigms (data lake, warehouse, lakehouse), modeling approaches (dimensional, normalized, data vault, wide tables), data…

ancoleman/ai-design-components

Implement applications using Google Cloud Platform (GCP) services.

ancoleman/ai-design-components

Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.

ancoleman/ai-design-components

Cloudflare Worker telemetry at the fetch boundary — OTLP traces / metrics / logs + utels error tracking + D1 Proxy that emits slow-query warnings.

mizchi/skills

Analyzes CUT&RUN (Skene Henikoff 2017) and CUT&Tag (Kaya-Okur 2019) chromatin profiling data.

GPTomics/bioSkills

Identifies differentially bound ChIP-seq regions between conditions using DiffBind, csaw (sliding windows), DESeq2/edgeR/PyDESeq2 on count matrices, NormR (control-aware), or MAnorm2.

GPTomics/bioSkills

Normalizes ChIP-seq data using exogenous spike-in (ChIP-Rx with Drosophila chromatin per Orlando 2014 / Egan 2016; E.

GPTomics/bioSkills

Normalize read-depth copy-ratio profiles and segment them into copy-number regions using circular binary segmentation (CBS, DNAcopy), hidden Markov models, HaarSeg, and fused-lasso methods.

GPTomics/bioSkills

Call copy number variants with the GATK best-practices workflows — the somatic CNV pipeline (CollectReadCounts, DenoiseReadCounts with tangent normalization, ModelSegments, CallCopyRatioSegments)…

GPTomics/bioSkills

Query and download from NCBI Gene Expression Omnibus (GEO) and EMBL-EBI's BioStudies/ArrayExpress mirror.

GPTomics/bioSkills

Runs cases from the legend-engine SQL e2e parity corpus (TestPostgresParity, ~2300 SQL cases compared against a real Postgres) through the warm interpreted Pure LSP with pure-sql-e2e, so edits to…

finos/legend-engine

Use CloudBase document database Web SDK only for confirmed NoSQL collection work.

TencentCloudBase/CloudBase-AI-Toolkit

Running experiments out of the data warehouse instead of via dedicated experiment platforms.

rampstackco/claude-skills

用于系统设计面试出题；聚焦容量估算、可用性与一致性权衡、可观测性和故障恢复。

Snailclimb/interview-guide

Migrates .NET/C data access code from Oracle to PostgreSQL (Npgsql).

github/awesome-copilot

Build production RAG pipelines and persistent agent memory using Pinecone as the vector database backend.

github/awesome-copilot

A skill your agent uses when: SSMA console operations — create project, generate assessment report, convert schema, migrate data, Oracle to SQL Server migration, schema conversion, data migration

github/awesome-copilot

Use Redis over HTTP from serverless and edge runtimes with @upstash/redis, and add rate limiting with @upstash/ratelimit.

github/awesome-copilot

Audits Python + BigQuery pipelines for cost safety, idempotency, and production readiness.

github/awesome-copilot

Get best practices for Entity Framework Core. An agent skill from github/awesome-copilot.

github/awesome-copilot