skills.rest
ssssssssassssss
ssssssssassssssCOMMUNITY
Explore all skills by this author →
GitHub

enterprise-infrastructure

Configure Kailash infrastructure with StoreFactory, SQL dialects, and deployment levels.

Updated Apr 2, 2026
Search Tags:#infrastructure#idempotency#schema-versioning#task-queue#store-factory#dialect-portable-sql#worker-registry
One-click install
npx skills add https://github.com/ssssssssassssss/disease-risk-classifier --skill enterprise-infrastructure-ssssssssassssss
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: enterprise-infrastructure
Source: https://github.com/ssssssssassssss/disease-risk-classifier/tree/main/.claude/skills/15-enterprise-infrastructure
Command: npx skills add https://github.com/ssssssssassssss/disease-risk-classifier --skill enterprise-infrastructure-ssssssssassssss

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides a blueprint for building scalable, multi-environment Kailash infrastructure, enabling portable backends, environment-driven configuration, and consistent deployment patterns.

Core Features & Use Cases

  • Progressive infrastructure levels (Level 0 to Level 2) with environment-variable driven scaling
  • QueryDialect pattern enabling dialect-portable SQL across SQLite, PostgreSQL, MySQL
  • StoreFactory for centralized ConnectionManager sharing
  • SQL task queue and worker registry for multi-worker processing
  • Idempotency patterns with IdempotentExecutor and claim-execute-store
  • Schema versioning and lazy imports to support upgrade/downgrade safety

Quick Start

Configure environment variables (KAILASH_DATABASE_URL and KAILASH_QUEUE_URL) and initialize StoreFactory to start Level 1/2 deployments.

Frequently Asked Questions about enterprise-infrastructure

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I migrate infrastructure from local SQLite development to a shared backend?▼

Migrate local infrastructure by configuring environment variables like KAILASH_DATABASE_URL and KAILASH_QUEUE_URL, then initialize StoreFactory to scale from Level 0 local development to Level 1/2 shared backends.

How do I write portable SQL that works across SQLite, PostgreSQL, and MySQL?▼

Write portable SQL using the QueryDialect pattern, which abstracts database-specific syntax into a dialect-portable layer supporting SQLite, PostgreSQL, and MySQL for consistent multi-environment execution.

What's the best way to ensure idempotent task execution in a distributed worker queue?▼

Ensure idempotent task execution by implementing the IdempotentExecutor pattern with a claim-execute-store workflow, preventing duplicate processing across multiple workers in a SQL-backed task queue.

Do I need schema versioning to safely upgrade and downgrade my database infrastructure?▼

Schema versioning is required for safe database upgrades and downgrades, tracking applied schema changes to prevent data corruption during multi-environment infrastructure transitions.

Can I share a single ConnectionManager across multiple workers in a task queue?▼

Share a single ConnectionManager across multiple workers using StoreFactory, which centralizes connection pooling and distributes database access to registered workers in the task queue.

Why does my multi-worker task queue process the same job multiple times?▼

Duplicate job processing occurs without idempotency controls; implement the IdempotentExecutor pattern with claim-execute-store logic and a worker registry to prevent concurrent duplicate task execution.

Related Skills

Explore More Software Engineering Skills→
FindMalekFindMalek
9

prisma-database-setup

Configure Prisma for multiple database providers and set up the client.

Community
Intermediate
terrene-foundationterrene-foundation
2

enterprise-infrastructure

Deploy scalable Kailash infrastructure from SQLite to multi-worker using environment variables.

Official
Advanced
myeohVmzrka92myeohVmzrka92

enterprise-infrastructure

Scale Kailash infrastructure from SQLite to shared-database and multi-worker deployments.

Community
Advanced
jguadagnojguadagno
18

sql-schema

Automate database schema setup and migration with SQL scripts in AppHost.

Community
Intermediate