Data & backend
10,176 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
ronnythedev/dotnet-clean-architecture-skills/cli/dist/skills/12-dotnet-jwt-authentication Skill
no license69★ repoConfigures JWT Bearer authentication for .NET APIs. Includes token generation, validation, refresh tokens, and user context extraction from claims.
13 dotnet permission authorization
ronnythedev/dotnet-clean-architecture-skills/cli/dist/skills/13-dotnet-permission-authorization Skill
no license69★ repoImplements permission-based authorization with custom attributes, policy providers, and authorization handlers. Provides granular access control beyond simple role-based authorization.
ronnythedev/dotnet-clean-architecture-skills/cli/dist/skills/24-dotnet-rate-limiting Skill
no license69★ repoImplements ASP.NET Core rate limiting middleware for API protection. Covers fixed window, sliding window, token bucket, and concurrency limiters with custom policies.
25.1 dotnet postgresql best practices
ronnythedev/dotnet-clean-architecture-skills/cli/dist/skills/25.1-dotnet-postgresql-best-practices Skill
no license69★ repoPostgreSQL database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Npgsql and EF Core.
25.2 dotnet sqlserver best practices
ronnythedev/dotnet-clean-architecture-skills/cli/dist/skills/25.2-dotnet-sqlserver-best-practices Skill
no license69★ repoSQL Server database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Microsoft.Data.SqlClient and EF Core.
ronnythedev/dotnet-clean-architecture-skills/skills/12-dotnet-jwt-authentication Skill
no license69★ repoConfigures JWT Bearer authentication for .NET APIs. Includes token generation, validation, refresh tokens, and user context extraction from claims.
The same file is in 4 other repositories
13 dotnet permission authorization
ronnythedev/dotnet-clean-architecture-skills/skills/13-dotnet-permission-authorization Skill
no license69★ repoImplements permission-based authorization with custom attributes, policy providers, and authorization handlers. Provides granular access control beyond simple role-based authorization.
The same file is in 4 other repositories
ronnythedev/dotnet-clean-architecture-skills/skills/24-dotnet-rate-limiting Skill
no license69★ repoImplements ASP.NET Core rate limiting middleware for API protection. Covers fixed window, sliding window, token bucket, and concurrency limiters with custom policies.
The same file is in 4 other repositories
25.1 dotnet postgresql best practices
ronnythedev/dotnet-clean-architecture-skills/skills/25.1-dotnet-postgresql-best-practices Skill
no license69★ repoPostgreSQL database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Npgsql and EF Core.
The same file is in 4 other repositories
25.2 dotnet sqlserver best practices
ronnythedev/dotnet-clean-architecture-skills/skills/25.2-dotnet-sqlserver-best-practices Skill
no license69★ repoSQL Server database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Microsoft.Data.SqlClient and EF Core.
The same file is in 4 other repositories
zakariaf/Flutter-Skills/skills/run-migration Skill
67★ repoRuns the forward-only Drift/SQLite schema-migration ritual — the most dangerous deterministic operation in an offline-first app: a bad migration silently destroys on-device rows that exist nowhere else. Enforces the exact ordered sequence: take a pre-migration file snapshot before the database is opened, bump schemaVersion by exactly one, write an append-only stepByStep forward step (never edit a shipped step, never write a down migration), commit the drift_dev make-migrations schema snapshot, regenerate, then prove it with tests covering every from→to path (incl. multi-version jumps), a write-at-v(n)/read-at-v(n+1) content test, PRAGMA integrity_check + foreign_key_check, and a forced mid-migration throw that restores the snapshot. Manual, side-effecting workflow. Use when adding or altering a Drift table, column, index, or CHECK; bumping schemaVersion; editing onUpgrade/stepByStep; or writing migration tests.
The same file is in 1 other repository
vaquarkhan/data-engineering-agent-skills/skills/dbt-and-analytics-engineering Skill
64★ repoGuides agents through analytics engineering workflows with dbt. Use when building or modifying staging models, marts, tests, snapshots, documentation, exposures, or semantic-layer-facing models.
Debezium and kafka connect cdc
vaquarkhan/data-engineering-agent-skills/skills/debezium-and-kafka-connect-cdc Skill
64★ repoGuides agents through Debezium and Kafka Connect CDC workflows. Use when streaming database changes into Kafka topics, managing connectors, snapshots, schema evolution, or downstream CDC consumers.
Enterprise etl and data integration modernization
vaquarkhan/data-engineering-agent-skills/skills/enterprise-etl-and-data-integration-modernization Skill
64★ repoGuides agents through operating, hardening, and modernizing enterprise ETL and integration stacks such as Informatica, Talend, DataStage, SSIS, and Matillion. Use when legacy mappings, job orchestration, migration, or coexistence with modern lakehouse patterns must be handled safely.
Etl elt and modernization strategy
vaquarkhan/data-engineering-agent-skills/skills/etl-elt-and-modernization-strategy Skill
64★ repoGuides agents through ETL, ELT, and transformation-modernization decisions. Use when choosing execution boundaries, redesigning transformation layers, or moving from legacy ETL estates to warehouse- or lakehouse-centered ELT patterns.
Kafka resilience and schema evolution
vaquarkhan/data-engineering-agent-skills/skills/kafka-resilience-and-schema-evolution Skill
64★ repoEnforces production Kafka guardrails including non-breaking schema evolution, dead-letter queues for poison messages, and acks=all producer durability. Use when designing or changing Kafka topics, producers, consumers, schema registry policies, or streaming recovery paths.
Reverse etl and operational data serving
vaquarkhan/data-engineering-agent-skills/skills/reverse-etl-and-operational-data-serving Skill
64★ repoGuides agents through reverse ETL and operational data serving workflows. Use when sending curated warehouse data to business systems, SaaS tools, APIs, activation layers, or operational applications that rely on stable downstream contracts.
Streaming and messaging systems
vaquarkhan/data-engineering-agent-skills/skills/streaming-and-messaging-systems Skill
64★ repoGuides agents through event streaming and real-time data pipeline design. Use when working with Kafka, Kinesis, Flink, stream processing, windowing, stateful consumers, or near-real-time publish flows.
Motherduck build data pipeline
motherduckdb/agent-skills/plugins/motherduck-skills-claude/skills/motherduck-build-data-pipeline Skill
no license62★ repoOpinionated AI agent skills for building applications with MotherDuck
motherduckdb/agent-skills/plugins/motherduck-skills-claude/skills/motherduck-connect Skill
no license62★ repoConnect to MotherDuck from any application. Use when setting up database connectivity via the Postgres endpoint (recommended), pg_duckdb, native DuckDB API, or JDBC. Covers connection strings, authentication, SSL, and environment variable configuration.
motherduckdb/agent-skills/plugins/motherduck-skills-claude/skills/motherduck-duckdb-sql Skill
no license62★ repoDuckDB SQL reference for MotherDuck. Use when you need exact DuckDB syntax or function behavior, friendly SQL features like QUALIFY, GROUP BY ALL, or list/struct types, MotherDuck-specific SQL such as shares, secrets, snapshots, or UNDROP, or to fix SQL errors and PostgreSQL-style SQL that fails on MotherDuck.
motherduckdb/agent-skills/plugins/motherduck-skills-claude/skills/motherduck-load-data Skill
no license62★ repoLoad and ingest data into MotherDuck from local files, object storage (S3, GCS, Azure, R2), HTTPS, dataframes, or external databases. Use for any import or bulk-load task — CSV, Parquet, JSON, Delta, Iceberg, local DuckDB database upload — and for choosing between CTAS, INSERT...SELECT, COPY, cloud-storage secrets, and Postgres-endpoint versus native DuckDB-client paths.
motherduckdb/agent-skills/plugins/motherduck-skills-claude/skills/motherduck-model-data Skill
no license62★ repoDesign and build database schemas and data models in MotherDuck. Produces a file-based SQL project scaffold with a model manifest. Use for any schema design or data modeling task — creating tables, choosing data types, star schemas, wide denormalized tables, raw/staging/analytics layers, dbt-style transformation projects, or restructuring data for analytics workloads.
motherduckdb/agent-skills/plugins/motherduck-skills-claude/skills/motherduck-rest-api Skill
no license62★ repoMotherDuck REST API control-plane reference. Use when calling api.motherduck.com or MotherDuck MCP admin tools to provision service accounts, manage tokens, configure Ducklings, or mint Dive embed sessions. Not for SQL or data-plane query work.
Motherduck build data pipeline
motherduckdb/agent-skills/plugins/motherduck-skills/skills/motherduck-build-data-pipeline Skill
no license62★ repoDesign an end-to-end MotherDuck data pipeline. Use for ETL/ELT workflows -- choosing raw, staging, and analytics boundaries, bulk ingestion paths, transformation sequencing, dlt/dbt integration, publication targets, or whether DuckLake is actually required.
motherduckdb/agent-skills/plugins/motherduck-skills/skills/motherduck-connect Skill
no license62★ repoConnect to MotherDuck from any application. Use when setting up database connectivity via the Postgres endpoint (recommended), pg_duckdb, native DuckDB API, or JDBC. Covers connection strings, authentication, SSL, and environment variable configuration.
motherduckdb/agent-skills/plugins/motherduck-skills/skills/motherduck-duckdb-sql Skill
no license62★ repoDuckDB SQL reference for MotherDuck. Use when you need exact DuckDB syntax or function behavior, friendly SQL features like QUALIFY, GROUP BY ALL, or list/struct types, MotherDuck-specific SQL such as shares, secrets, snapshots, or UNDROP, or to fix SQL errors and PostgreSQL-style SQL that fails on MotherDuck.
motherduckdb/agent-skills/plugins/motherduck-skills/skills/motherduck-load-data Skill
no license62★ repoLoad and ingest data into MotherDuck from local files, object storage (S3, GCS, Azure, R2), HTTPS, dataframes, or external databases. Use for any import or bulk-load task — CSV, Parquet, JSON, Delta, Iceberg, local DuckDB database upload — and for choosing between CTAS, INSERT...SELECT, COPY, cloud-storage secrets, and Postgres-endpoint versus native DuckDB-client paths.
motherduckdb/agent-skills/plugins/motherduck-skills/skills/motherduck-model-data Skill
no license62★ repoDesign and build database schemas and data models in MotherDuck. Produces a file-based SQL project scaffold with a model manifest. Use for any schema design or data modeling task — creating tables, choosing data types, star schemas, wide denormalized tables, raw/staging/analytics layers, dbt-style transformation projects, or restructuring data for analytics workloads.
motherduckdb/agent-skills/plugins/motherduck-skills/skills/motherduck-rest-api Skill
no license62★ repoMotherDuck REST API control-plane reference. Use when calling api.motherduck.com or MotherDuck MCP admin tools to provision service accounts, manage tokens, configure Ducklings, or mint Dive embed sessions. Not for SQL or data-plane query work.
Motherduck build data pipeline
motherduckdb/agent-skills/skills/motherduck-build-data-pipeline Skill
no license62★ repoDesign an end-to-end MotherDuck data pipeline. Use for ETL/ELT workflows -- choosing raw, staging, and analytics boundaries, bulk ingestion paths, transformation sequencing, dlt/dbt integration, publication targets, or whether DuckLake is actually required.
motherduckdb/agent-skills/skills/motherduck-connect Skill
no license62★ repoConnect to MotherDuck from any application. Use when setting up database connectivity via the Postgres endpoint (recommended), pg_duckdb, native DuckDB API, or JDBC. Covers connection strings, authentication, SSL, and environment variable configuration.
The same file is in 1 other repository
motherduckdb/agent-skills/skills/motherduck-duckdb-sql Skill
no license62★ repoDuckDB SQL reference for MotherDuck. Use when you need exact DuckDB syntax or function behavior, friendly SQL features like QUALIFY, GROUP BY ALL, or list/struct types, MotherDuck-specific SQL such as shares, secrets, snapshots, or UNDROP, or to fix SQL errors and PostgreSQL-style SQL that fails on MotherDuck.
The same file is in 2 other repositories
motherduckdb/agent-skills/skills/motherduck-load-data Skill
no license62★ repoLoad and ingest data into MotherDuck from local files, object storage (S3, GCS, Azure, R2), HTTPS, dataframes, or external databases. Use for any import or bulk-load task — CSV, Parquet, JSON, Delta, Iceberg, local DuckDB database upload — and for choosing between CTAS, INSERT...SELECT, COPY, cloud-storage secrets, and Postgres-endpoint versus native DuckDB-client paths.
The same file is in 2 other repositories
motherduckdb/agent-skills/skills/motherduck-model-data Skill
no license62★ repoDesign and build database schemas and data models in MotherDuck. Produces a file-based SQL project scaffold with a model manifest. Use for any schema design or data modeling task — creating tables, choosing data types, star schemas, wide denormalized tables, raw/staging/analytics layers, dbt-style transformation projects, or restructuring data for analytics workloads.
The same file is in 2 other repositories
motherduckdb/agent-skills/skills/motherduck-rest-api Skill
no license62★ repoMotherDuck REST API control-plane reference. Use when calling api.motherduck.com or MotherDuck MCP admin tools to provision service accounts, manage tokens, configure Ducklings, or mint Dive embed sessions. Not for SQL or data-plane query work.
The same file is in 1 other repository
bxmaximum/bitrix-framework-skills/skills/bitrix-caching Skill
62★ repoCovers caching in Bitrix — Cache (unmanaged), ManagedCache, TaggedCache, ORM auto-cache, component cache via startResultCache/endResultCache, Composite Site, cache engine configuration (files, memcached, redis) in .settings.php. Applied when optimizing performance, invalidating by tags and events, setting TTL, cache warm-up, and debugging cache hits. Key terms — cache, invalidate, TaggedCache, ManagedCache, startResultCache, cacheDir, clean.
bxmaximum/bitrix-framework-skills/skills/bitrix-database Skill
62★ repoCovers direct database work in Bitrix — Application::getConnection(), Connection, MysqliConnection, SqlHelper, SqlExpression, raw SQL queries via query()/queryExecute()/queryScalar(), transactions (startTransaction/commitTransaction/rollbackTransaction), DDL and schema migrations, bulk operations (insertBatch, addMulti), additional connections via the connections section in .settings.php. Applied when ORM is insufficient — bulk operations, raw SQL, migrations, working with external databases, and building custom queries. Key terms — Connection, SqlHelper, SqlExpression, transaction, raw SQL, bulk insert, DDL, migration.
bxmaximum/bitrix-framework-skills/skills/bitrix-orm Skill
62★ repoD7 ORM tablets, ConditionTree queries, Objectify, batch/merge/deleteByFilter writes. Use for entity design, reads, and persistence.
bxmaximum/bitrix-framework-skills/skills/bitrix-postgresql Skill
62★ repoCovers PostgreSQL support in Bitrix — PgsqlConnection, migration from MySQL, compatible code, module support matrix. Applied when configuring or migrating to PostgreSQL Enterprise editions. Key terms — PostgreSQL, PgsqlConnection, migration, compatible-code.
bxmaximum/bitrix-framework-skills/skills/bitrix-sessions Skill
62★ repoCovers Bitrix sessions — Application::getSession(), getKernelSession(), getLocalSession(), BX_SECURITY_SESSION_READONLY and BX_SECURITY_SESSION_VIRTUAL modes, storages (cache, database, redis, null session handler), separated session mode in .settings.php. Applied instead of direct $_SESSION access, when optimizing AJAX session locks, configuring alternative storages, and separating kernel/local sessions. Key terms — session, getSession, session storage, BX_SECURITY_SESSION_READONLY, separated session, getKernelSession, getLocalSession.
waystation-ai/mcp/ai.waystation/postgres MCP server
no license60★ repoConnect to your PostgreSQL database to query data and schemas.
ComeOnOliver/skillshub/skills/Aaronontheweb/dotnet-skills/database-performance Skill
59★ repoDatabase access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins. Works with EF Core and Dapper.
ComeOnOliver/skillshub/skills/Bamose/everything-codex-cli/backend-patterns Skill
59★ repoBackend architecture patterns, API design, database optimization, and server-side best practices for Hono, Cloudflare Workers, and Next.js Route Handlers.
ComeOnOliver/skillshub/skills/Bamose/everything-codex-cli/clickhouse-io Skill
59★ repoClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
ComeOnOliver/skillshub/skills/CharlesWiltgen/Axiom/axiom-database-migration Skill
59★ repoUse when adding/modifying database columns, encountering "FOREIGN KEY constraint failed", "no such column", "cannot add NOT NULL column" errors, or creating schema migrations for SQLite/GRDB/SQLiteData - prevents data loss with safe migration patterns and testing workflows for iOS/macOS apps
ComeOnOliver/skillshub/skills/CharlesWiltgen/Axiom/axiom-grdb Skill
59★ repoUse when writing raw SQL queries with GRDB, complex joins, ValueObservation for reactive queries, DatabaseMigrator patterns, query profiling under performance pressure, or dropping down from SQLiteData for performance - direct SQLite access for iOS/macOS
ComeOnOliver/skillshub/skills/CharlesWiltgen/Axiom/axiom-ios-data Skill
59★ repoUse when working with ANY data persistence, database, axiom-storage, CloudKit, migration, or serialization. Covers SwiftData, Core Data, GRDB, SQLite, CloudKit sync, file storage, Codable, migrations.
ComeOnOliver/skillshub/skills/CharlesWiltgen/Axiom/axiom-push-notifications-ref Skill
59★ repoUse when needing APNs HTTP/2 transport details, JWT authentication setup, payload key reference, UNUserNotificationCenter API, notification category/action registration, service extension lifecycle, local notification triggers, Live Activity push headers, or broadcast push format. Covers complete push notification API surface.
ComeOnOliver/skillshub/skills/CloudAI-X/claude-workflow-v2/convex-backend Skill
59★ repoConvex backend development guidelines. Use when writing Convex functions, schemas, queries, mutations, actions, or any backend code in a Convex project. Triggers on tasks involving Convex database operations, real-time subscriptions, file storage, or serverless functions.
ComeOnOliver/skillshub/skills/CloudAI-X/claude-workflow-v2/database-design Skill
59★ repoDesigns database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases. Use when designing tables, optimizing queries, fixing N+1 problems, planning migrations, or when asked about database performance, normalization, ORMs, or data modeling.
ComeOnOliver/skillshub/skills/CloudAI-X/claude-workflow-v2/security-patterns Skill
59★ repoImplements authentication, authorization, encryption, secrets management, and security hardening patterns. Use when designing auth flows, managing secrets, configuring CORS, implementing rate limiting, or when asked about JWT, OAuth, password hashing, API keys, RBAC, or security best practices.
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/apify-automation Skill
59★ repoAutomate web scraping and data extraction with Apify -- run Actors, manage datasets, create reusable tasks, and retrieve crawl results through the Composio Apify integration.
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/contentful-graphql-automation Skill
59★ repoAutomate Contentful Graphql tasks via Rube MCP (Composio). Always search tools first for current schemas.
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/firecrawl-automation Skill
59★ repoAutomate web crawling and data extraction with Firecrawl -- scrape pages, crawl sites, extract structured data, batch scrape URLs, and map website structures through the Composio Firecrawl integration.
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/onesignal-rest-api-automation Skill
59★ repoAutomate OneSignal tasks via Rube MCP (Composio). Always search tools first for current schemas.
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/onesignal_rest_api-automation Skill
59★ repoAutomate OneSignal tasks via Rube MCP (Composio): push notifications, segments, templates, and messaging. Always search tools first for current schemas.
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/phantombuster-automation Skill
59★ repoAutomate lead generation, web scraping, and social media data extraction workflows through PhantomBuster's cloud platform via Composio
ComeOnOliver/skillshub/skills/ComposioHQ/awesome-claude-skills/prisma-automation Skill
59★ repoAutomate Prisma tasks via Rube MCP (Composio). Always search tools first for current schemas.
ComeOnOliver/skillshub/skills/Decodo/decodo-openclaw-skill/SKILL.md Skill
59★ repoSearch Google, scrape web pages, Amazon product pages, YouTube subtitles, or Reddit (post/subreddit) using the Decodo Scraper OpenClaw Skill.