Data & backend
10,137 rows, by stacks then stars
233 of these skill files have been read, by 258 distinct authors, and what they tell an agent counted. What Data & backend authors agree on, and what they forbid
Malikasadjaved/skills/qdrant-fastapi-integration Skill
no license0★ repoUse when integrating Qdrant into a FastAPI async service — creating collections, batch upsert with UUID5 IDs, multi-tenant payload filtering with FieldCondition/MatchValue, HNSW tuning, lifespan-managed QdrantClient injection, and Qdrant Cloud vs local Docker setup. Complements qdrant/skills with FastAPI application-layer patterns not covered there.
Anthropic compatible endpoint swap
kjuhwa/skills-hub/skills/agent-sdk/anthropic-compatible-endpoint-swap Skill
0★ repoPoint the Claude Agent SDK at any Anthropic-compatible endpoint (OpenRouter, Vercel AI Gateway, Ollama, custom) by setting ANTHROPIC_BASE_URL + ANTHROPIC_AUTH_TOKEN before instantiating — no SDK changes, no adapter layer.
Coding agent cli backend interface
kjuhwa/skills-hub/skills/agents/coding-agent-cli-backend-interface Skill
0★ repoUnified Go/TS interface for invoking any coding-agent CLI (Claude, Codex, OpenCode, Gemini, Cursor, etc.) behind one streaming Execute/Session/Result contract.
New ml backend dependency audit
kjuhwa/skills-hub/skills/agents/new-ml-backend-dependency-audit Skill
0★ repoRun a Phase-0 dependency audit on a candidate ML library before writing any integration code, so PyInstaller and runtime surprises are caught early.
Domain category endpoint registry
kjuhwa/skills-hub/skills/arch/domain-category-endpoint-registry Skill
0★ repoOrganize a large vendor-API client (100s of endpoints) under a three-level `{domain}/{category}/{Action}{Entity}` package convention with a shared base class and a single `initializeEndpoints()` registry — scalable, greppable, and uniformly logged.
Kafka avro topic auto create config
kjuhwa/skills-hub/skills/arch/kafka-avro-topic-auto-create-config Skill
0★ repoSpring Boot Kafka config bean that auto-creates topics on startup via ApplicationRunner, with Avro serde, manual-ack listener, and bounded concurrency
Kafka engine distributed job framework
kjuhwa/skills-hub/skills/arch/kafka-engine-distributed-job-framework Skill
0★ repoKafka 이벤트 기반 분산 작업 실행 프레임워크 스켈레톤 — Publisher→Topic→Consumer→Queue→Worker + Admission Control + Strategy SPI
Avro gradle kafka schema pipeline
kjuhwa/skills-hub/skills/backend/avro-gradle-kafka-schema-pipeline Skill
0★ repoWire the davidmc24 Avro Gradle plugin so .avsc schemas generate Java sources consumed by Kafka producers/consumers with Confluent Schema Registry
Challenge response auth redis ttl
kjuhwa/skills-hub/skills/backend/challenge-response-auth-redis-ttl Skill
0★ repoReplay-resistant two-step login — server issues a short-lived random challenge stored in Redis with TTL, client signs/hashes response, bounded attempts per key
kjuhwa/skills-hub/skills/backend/distributed-lock-mongodb Skill
0★ repoMongoDB findAndModify-based distributed lock with TTL expiry, owner tagging, and retry loop for multi-instance Spring Boot services.
kjuhwa/skills-hub/skills/backend/event-driven-kafka-scheduling Skill
0★ repoReplace Spring @Scheduled with a Kafka-delivered JobExecuteNotice so a central scheduler service fans out tick events — with a skip-if-previous-still-running guard to prevent pile-up.
Jdbc configurable sql insert sender
kjuhwa/skills-hub/skills/backend/jdbc-configurable-sql-insert-sender Skill
0★ repoShip a notification/integration channel that writes to a user-configured external DB via user-supplied INSERT SQL with ${var} placeholders
Jwt extraction via base controller
kjuhwa/skills-hub/skills/backend/jwt-extraction-via-base-controller Skill
0★ repoConsolidate repeated `JwtTokenService.getXxxFromBearerToken(headerAuthorization)` calls across Spring controllers by moving the service and helper methods onto a shared `BaseController`. Subclass controllers call `getOrganizationId(h)` / `getLoginId(h)` / `getRoleIds(h)` directly.
kjuhwa/skills-hub/skills/backend/kafka-avro-producer-gzip-30mb Skill
0★ repoSpring Kafka producer config for Avro values with gzip compression and a raised 30MB max.request.size for schema-registry payloads
Kafka batch consumer partition tuning
kjuhwa/skills-hub/skills/backend/kafka-batch-consumer-partition-tuning Skill
0★ repoSize Kafka partition count + max-poll-records per topic volume so heavy-processing batch consumers avoid max.poll.interval.ms breaches and maintain throughput via per-partition concurrency.
Kafka consumer config 3 factories
kjuhwa/skills-hub/skills/backend/kafka-consumer-config-3-factories Skill
0★ repoSpring Kafka consumer setup with three ListenerContainerFactory variants (standard / batch / UUID-group) and autoStartup=false to allow topic bootstrap before listeners attach
Kafka consumer errorhandling wrapper
kjuhwa/skills-hub/skills/backend/kafka-consumer-errorhandling-wrapper Skill
0★ repoWrap key/value deserializers in Spring Kafka's ErrorHandlingDeserializer so a single poison record doesn't halt the consumer
Kafka consumer semaphore chunking
kjuhwa/skills-hub/skills/backend/kafka-consumer-semaphore-chunking Skill
0★ repoBound in-flight async work from a Kafka consumer with `Semaphore(poolSize + queueCapacity - 2)` plus fixed-size chunks; release in `whenComplete` on both success and failure.
kjuhwa/skills-hub/skills/backend/kafka-consumer-tenant-fan-out Skill
0★ repo@KafkaListener pattern consuming a topicPattern across tenants, using a record header for tenant identity and routing to per-tenant downstream streams
Kafka debounce event coalescing
kjuhwa/skills-hub/skills/backend/kafka-debounce-event-coalescing Skill
0★ repoCoalesce bursts of change events into one Kafka event per tenant per debounce window using Redis state (first/last change time + changed-tenant SET), with a MAX_WAIT fallback so a never-quiet stream still fires.
kjuhwa/skills-hub/skills/backend/kafka-message-header-metadata Skill
0★ repoAttach org-id, user-id, and timestamp as RecordHeader[] on a ProducerRecord to enable multi-tenant event routing without polluting the Avro payload
kjuhwa/skills-hub/skills/backend/kafka-producer-async-callback Skill
0★ repoFire-and-log Kafka send pattern using CompletableFuture.whenComplete() for audit/event topics where the caller should not block
Kafka producer config avro schema registry
kjuhwa/skills-hub/skills/backend/kafka-producer-config-avro-schema-registry Skill
0★ repoKafka producer config template for Avro + Confluent Schema Registry with LZ4 compression, 30MB max request size, and acks=1
Message loader gated on database ready
kjuhwa/skills-hub/skills/backend/message-loader-gated-on-database-ready Skill
0★ repoGate i18n/seed loading on database readiness + per-tenant distributed lock so the first instance wins initialization in a multi-replica rollout.
Mongodb changestream field filter
kjuhwa/skills-hub/skills/backend/mongodb-changestream-field-filter Skill
0★ repoFilter MongoDB change stream UPDATE events by inspecting updateDescription.updatedFields so irrelevant mutations do not trigger downstream work; INSERT/DELETE fall through as always-relevant.
Mongodb compound index esr rule
kjuhwa/skills-hub/skills/backend/mongodb-compound-index-esr-rule Skill
0★ repoOrder MongoDB compound-index fields as Equality → Sort → Range so the query planner keeps a tight IXSCAN and avoids in-memory sorts.
Mongodb datetrunc binsize zero guard
kjuhwa/skills-hub/skills/backend/mongodb-datetrunc-binsize-zero-guard Skill
0★ repoGuard MongoDB $dateTrunc binSize against 0 when your interval may be auto/unset; coerce to 1 to avoid runtime error
Multi tenant kafka header organization context
kjuhwa/skills-hub/skills/backend/multi-tenant-kafka-header-organization-context Skill
0★ repoPropagate tenant/organization id from Kafka headers through async handler threads via a ThreadLocal context holder
Multi tenant scheduler iteration
kjuhwa/skills-hub/skills/backend/multi-tenant-scheduler-iteration Skill
0★ repoPattern for scheduled jobs that must iterate every tenant DB in a database-per-tenant MongoDB setup: enumerate DBs, filter system ones, set TenantContext per tenant, isolate failures, clear in finally.
Org scoped kafka topic bootstrap
kjuhwa/skills-hub/skills/backend/org-scoped-kafka-topic-bootstrap Skill
0★ repoOn-startup and on-event creation of per-tenant Kafka topics, with retention overrides per topic class and a service-readiness gate
Redis lock recheck flag pattern
kjuhwa/skills-hub/skills/backend/redis-lock-recheck-flag-pattern Skill
0★ repoDistributed Redis lock with a "recheck" flag so concurrent events arriving while the lock is held force the holder to run a second pass, instead of being silently dropped.
kjuhwa/skills-hub/skills/backend/stomp-principal-jwt-channel Skill
0★ repoSTOMP ChannelInterceptor that validates a JWT on CONNECT and binds a multi-tenant Principal (orgId + userId + sessionId) for downstream routing
Tenant per database mongo routing
kjuhwa/skills-hub/skills/backend/tenant-per-database-mongo-routing Skill
0★ repoRoute Spring Data Mongo operations to per-tenant databases via a ThreadLocal tenant holder and two MongoTemplate beans (isolated vs shared collections).
Testcontainers mongo kafka abstract base
kjuhwa/skills-hub/skills/backend/testcontainers-mongo-kafka-abstract-base Skill
0★ repoAbstract test base classes that spin up MongoDB + Kafka via Testcontainers with static start() and reuse=true, exposing mapped ports via System.setProperty
Version specific sql map selection
kjuhwa/skills-hub/skills/backend/version-specific-sql-map-selection Skill
0★ repoSelect MyBatis-style SQL maps at runtime by DBMS + version with graceful fallback to a default supported version
kjuhwa/skills-hub/skills/cli/bun-windows-copyfile-backend Skill
0★ repoBun on Windows 에서 `bun install` 이 `Failed to link ... EUNKNOWN` 으로 실패할 때, `--backend=copyfile` 로 symlink 경로를 파일 복사로 우회한다.
kjuhwa/skills-hub/skills/cli/github-hmac-webhook-verify Skill
0★ repoVerify a GitHub webhook's `X-Hub-Signature-256` using HMAC-SHA-256 over the raw body with `timingSafeEqual`, with a same-length guard, prefix-masked logs on mismatch, and a 200-then-async processing pattern.
Multi backend argparse dispatcher
kjuhwa/skills-hub/skills/cli/multi-backend-argparse-dispatcher Skill
0★ repoSingle argparse CLI that dispatches to per-backend implementations (transformers / sglang / vllm / mlx) by required --backend choice, with post-parse cross-flag validation.
Data pipeline visualization pattern
kjuhwa/skills-hub/skills/design/data-pipeline-visualization-pattern Skill
0★ repoVisual patterns for rendering multi-stage data pipelines with flow direction, stage health, and throughput indicators
Database sharding visualization pattern
kjuhwa/skills-hub/skills/design/database-sharding-visualization-pattern Skill
0★ repoCanvas-based rendering pattern for visualizing shard topology, key distribution, and routing decisions in database sharding systems
kjuhwa/skills-hub/skills/design/etl-visualization-pattern Skill
0★ repoCanvas-based visual representations for ETL flow, rules, and lineage with node-edge topology
kjuhwa/skills-hub/skills/design/graphql-visualization-pattern Skill
0★ repoVisualizing GraphQL operations (queries, schemas, subscriptions) through interactive node-graph and live-feed UIs
kjuhwa/skills-hub/skills/design/oauth-visualization-pattern Skill
0★ repoVisualizing OAuth flows, JWT structure, and scope relationships through staged, interactive diagrams
kjuhwa/skills-hub/skills/devops/gradle-bootrun-local-dev-env Skill
0★ repoGradle bootRun task recipe that wires local MongoDB/Kafka/Redis/MQTT/Eureka/Quartz via environment variables — no docker-compose needed
kjuhwa/skills-hub/skills/devops/mongodb-volume-copy-backup Skill
0★ repoBack up and restore MongoDB Docker volumes via rsync volume-copy instead of mongodump/tar.gz
kjuhwa/skills-hub/skills/devops/slack-webhook-notify Skill
0★ repoSlack Incoming Webhook으로 메시지를 전송한다. 빌드/테스트/배포 결과, 작업 완료 알림 등을 Slack 채널에 보낼 때 사용.
kjuhwa/skills-hub/skills/devops/sqlc-go-postgres-codegen Skill
0★ repoGenerate typed Go database access code from SQL files and migrations using sqlc — one source of truth per query, no ORM runtime overhead.
kjuhwa/skills-hub/skills/devops/worktree-env-file-isolation Skill
0★ repoPer-git-worktree environment files (.env.worktree) with deterministically derived unique database names and ports, sharing one Postgres container.
kjuhwa/skills-hub/skills/electron/oauth-define-at-buildtime Skill
0★ repoBake OAuth client IDs/secrets into the main-process bundle at build time via esbuild --define:process.env.X=... so they ship with the app, while user-provided secrets (Google) stay out of the build.
kjuhwa/skills-hub/skills/fastapi-streaming-endpoints/fastapi-sse-mcp-protocol Skill
0★ repoHost a hosted MCP (Model Context Protocol) server over FastAPI's StreamingResponse using API-key auth, a session dict, and a tool registry surfaced via the 2025-03-26 Streamable HTTP spec.
kjuhwa/skills-hub/skills/fastapi/spa-fallback-fastapi-mount Skill
0★ repoServe a built Vite/React SPA from FastAPI with asset mounting, catch-all routing, and path-traversal protection.
Shared apis endpoint service pattern
kjuhwa/skills-hub/skills/frontend/shared-apis-endpoint-service-pattern Skill
0★ repoModule Federation 모노레포에서 REST 엔드포인트를 추가할 때 `endpoint 상수 → services 메서드 → commonApiService 호출` 3계층 레이어링으로 도메인 일관성을 유지하는 패턴.
Github trending zero dep scraper
kjuhwa/skills-hub/skills/integration/github-trending-zero-dep-scraper Skill
0★ repoScrape https://github.com/trending for the daily/weekly/monthly top repos using only Node's built-in `https` module — no cheerio, no puppeteer, no fetch polyfill. Parse the `<article class="Box-row">` blocks with targeted regex and return a clean list of {owner, repo, language, starsToday}.
Linux display backend detector wayland x11
kjuhwa/skills-hub/skills/launcher/linux-display-backend-detector-wayland-x11 Skill
0★ repoDetect whether the current session is Wayland or X11, auto-route to XWayland for global hotkey support, and handle compositor-specific overrides (e.g. Niri which has no XWayland). Exports an Electron args array ready for exec.
Sandbox backend pluggable architecture
kjuhwa/skills-hub/skills/linux-sandbox/sandbox-backend-pluggable-architecture Skill
0★ repoThree-backend dispatcher (Host/Bwrap/KVM) with auto-detection priority and env override. Abstract base class defines the interface; concrete implementations handle isolation. Used to run untrusted subprocess workloads on Linux with progressive isolation.
Powersync add synced table two pr flow
kjuhwa/skills-hub/skills/powersync/powersync-add-synced-table-two-pr-flow Skill
0★ repoAdd a new PowerSync-synced table across frontend SQLite, backend Postgres, shared table registry, and sync-rules YAML using a strict two-PR process so the frontend never ships before the PowerSync Cloud dashboard rules exist.
Powersync no foreign keys on sync backend
kjuhwa/skills-hub/skills/powersync/powersync-no-foreign-keys-on-sync-backend Skill
0★ repoSkip composite foreign-key constraints on a PowerSync-style backend schema and use plain text columns for cross-table references, so partial syncs don't fail and encrypted columns don't block writes.
Sqlite idempotent column migration
kjuhwa/skills-hub/skills/python/sqlite-idempotent-column-migration Skill
0★ repoApply SQLite column-level schema migrations at every startup without Alembic, using existence checks plus table-rename for column removal.
Retrofit okhttp api endpoint extraction
kjuhwa/skills-hub/skills/reverse-engineering/retrofit-okhttp-api-endpoint-extraction Skill
0★ repoEnumerate and document all HTTP endpoints from decompiled Android code by grepping annotation/builder signatures (Retrofit @GET/@POST, OkHttp Request.Builder, Volley request classes) then capturing method, path, headers, body, response type, and call site for each hit.
Async jwt jwks cache with lock
kjuhwa/skills-hub/skills/security/async-jwt-jwks-cache-with-lock Skill
0★ repoAsync JWKS cache that uses one asyncio.Lock per JWKS URL to prevent thundering-herd refetch, with double-checked locking and TTL-based expiry; signature + issuer verified, kid-matched key extraction.