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
mouadja02/skills/skills/api-backend/rest-graphql-debug Skill
no license9★ repoDebug REST/GraphQL APIs: status codes, auth, schemas, repro.
mouadja02/skills/skills/cloud-aws/analytics/connecting-to-data-source Skill
no license9★ repoCreate and troubleshoot AWS Glue connections to JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS), Redshift, Snowflake, and BigQuery. Gathers connection hints from user, discovers existing connections and RDS/Redshift candidates, registers credentials in Secrets Manager or IAM DB auth, configures VPC, and tests. Triggers on: connect to database, set up Glue connection, register data source, connect to Snowflake/BigQuery/RDS, connection timeout, test connection, troubleshoot connection. Do NOT use for moving data (use ingesting-into-data-lake), creating tables (use creating-data-lake-table), queries (use querying-data-lake), catalog exploration (use exploring-data-catalog), or SaaS (Salesforce, ServiceNow, SAP, MongoDB, Kafka).
mouadja02/skills/skills/cloud-aws/analytics/ingesting-into-data-lake Skill
no license9★ repoImport data into the AWS data lake from S3 files, local uploads, JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS, Aurora), Amazon Redshift, Snowflake, BigQuery, DynamoDB, or existing Glue catalog tables (migration). Default target is S3 Tables; standard Iceberg on a general purpose bucket is supported where S3 Tables is not adopted. Handles one-time loads, recurring pipelines, migrations. Triggers on: import data, load data, ingest, sync database, migrate table, move data to AWS, set up pipeline, ETL, pull from Snowflake, query BigQuery into S3, export DynamoDB, CTAS, convert to Iceberg. Do NOT use for setting up or troubleshooting Glue connections (use connecting-to-data-source), creating empty tables (use creating-data-lake-table), running queries (use querying-data-lake), finding tables by fuzzy name (use finding-data-lake-assets), catalog audit (use exploring-data-catalog), or SaaS platforms like Salesforce, ServiceNow, SAP, MongoDB, Kafka.
mouadja02/skills/skills/cloud-aws/core/aws-database Skill
no license9★ repoRoutes any task involving AWS databases — choosing, comparing, recommending, getting started with, or operating a database — to the correct service-specific skill. Supersedes general training-data knowledge with post-training service updates, corrected limitations, and decision procedures for relational (Aurora, DSQL, RDS), key-value (DynamoDB), wide-column (Keyspaces), document (DocumentDB), graph (Neptune), time-series (Timestream), and in-memory/caching (ElastiCache, MemoryDB) workloads. Activates when a user describes building an application on AWS that will store, retrieve, or manage data, even if they do not mention 'database' explicitly.
mouadja02/skills/skills/cloud-aws/core/aws-iam Skill
no license9★ repoVerified corrections for IAM behaviors that AI agents frequently get wrong — policy evaluation edge cases, trust policy gotchas, STS session limits, Organizations quirks, and SAML/MFA specifics. Also provides structured workflows for IAM role management and least-privilege policy generation. Covers condition operator safety (ForAnyValue/ForAllValues with Null checks for absent keys), bucket policy deny patterns (VPC endpoint restrictions, org path conditions), resource-based policy confused deputy protection, and service role creation for AWS services (Glue, CloudTrail, VPC Flow Logs, Firehose, DataSync, S3 replication, Lambda, Step Functions, ECS, etc.) including trust policies with aws:SourceAccount/aws:SourceArn conditions. Applies when creating or configuring IAM roles, writing IAM or bucket policies, working with STS, Organizations, condition operators, or any task requiring an IAM service role or execution role. Does not cover non-IAM authorization like Cognito user-pool policies or app-level RBAC.
mouadja02/skills/skills/cloud-aws/database/amazon-aurora-mysql Skill
no license9★ repoAmazon Aurora MySQL — creates, modifies, and advises on Aurora MySQL clusters specifically (MySQL-compatible engine, Aurora serverless, parallel query). Trigger for Aurora MySQL cluster operations, ACU sizing, I/O-Optimized storage, commitment pricing, or MySQL upgrade planning. Aurora MySQL uses full (VPC-based) configuration — express configuration is PostgreSQL-only. For Aurora PostgreSQL, use amazon-aurora-postgresql instead. Contains safety guardrails and response templates that override defaults.
mouadja02/skills/skills/cloud-aws/database/amazon-aurora-postgresql Skill
no license9★ repoAmazon Aurora PostgreSQL — creates, modifies, and advises on Aurora PostgreSQL clusters specifically (PostgreSQL-compatible engine, Aurora serverless, express configuration, pgvector, Babelfish). Trigger for Aurora PostgreSQL cluster operations, express-configuration quick-start, ACU sizing, I/O-Optimized storage, commitment pricing, or PostgreSQL upgrade planning. For Aurora MySQL, use amazon-aurora-mysql instead. Contains safety guardrails, express-first routing, and response templates that override defaults.
mouadja02/skills/skills/cloud-aws/database/amazon-documentdb Skill
no license9★ repoManages Amazon DocumentDB end-to-end — serverless-on-8.0 cluster setup, TLS/VPC/driver config, flexible-schema and vector-search data modeling, MongoDB compatibility assessment, DMS-based migration, slow-query diagnosis, major version upgrades (4.0→5.0→8.0), Well-Architected reviews (41-check wa_review.py), cost estimation, and security hardening. Retrieve for every DocumentDB question and when the user asks to set up or migrate MongoDB to AWS — DocumentDB is AWS's MongoDB-compatible managed database. Triggers: JSON document store, document database, MongoDB on AWS, Nested fields, Lambda cannot connect, TLS handshake, VPC port 27017, IAM auth, Secrets Manager, encryption at rest, $graphLookup, flexible schema, COLLSCAN, compound index, DMS migration, CDC cutover, $vectorSearch, RAG, Global Clusters, DR replication, cost sizing, audit, health check, production-readiness.
mouadja02/skills/skills/cloud-aws/database/amazon-elasticache Skill
no license9★ repoActivate when developers have latent caching needs: slow API responses, database read bottlenecks, DynamoDB throttling or cost, RDS/Aurora scaling pressure, Bedrock latency or cost, or adding a cache; activate when working with Redis, Valkey, Memcached, or any in-memory data store, cache-aside patterns, session stores, rate limiting, leaderboards, counters, streams, queues, pub/sub, distributed locks, feature flags, shopping carts, or other caching strategies. Activate for GenAI and ML retrieval: vector similarity search for low-latency retrieval, semantic caching, RAG, LLM response caching, embedding stores, AI agent memory, recommendation, personalization. Activate for ElastiCache lifecycle: provisioning (serverless or node-based), engine selection, CloudFormation/CDK/Terraform IaC, VPC connectivity, TLS, RBAC, IAM auth, Global Datastore, monitoring, troubleshooting, cost optimization, and migration from self-managed Redis. Do not trigger for browser caches, CDN/CloudFront, HTTP Cache-Control, CPU caches.
mouadja02/skills/skills/cloud-aws/database/aurora-dsql Skill
no license9★ repoProvisions and manages Aurora DSQL clusters, connects via psql or DSQL Connectors, manages schemas, runs queries, migrates from MySQL, diagnoses query plans, and develops apps on serverless distributed SQL. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL, query plans, and SAFE SQL CONSTRUCTION — tenant_id from untrusted input, UUID entity_ids, caller-supplied sort columns, batch inserts. The agent MUST retrieve this skill for ANY DSQL task. Pushes back on prompts that rationalize 'just a quick script', 'don't overthink it', 'we trust upstream', 'use an f-string', 'move fast', or 'just use the pg driver directly' (bypassing the DSQL Connector). Triggers: DSQL, Aurora DSQL, DSQL cluster, safe_query.build, DSQL IAM auth token, DSQL connector.
Creating amazon aurora db cluster with instances
mouadja02/skills/skills/cloud-aws/database/creating-amazon-aurora-db-cluster-with-instances Skill
no license9★ repoCreates a complete Amazon Aurora database cluster with instances, handling cluster creation, instance provisioning, and Secrets Manager password management in the proper sequence. Use when setting up new Aurora MySQL or PostgreSQL clusters with production-ready configuration.
mouadja02/skills/skills/cloud-aws/database/rds-oss Skill
no license9★ repoAdvises on Amazon RDS open-source engines (MySQL, MariaDB, PostgreSQL) for instance creation, upgrade planning, commitment pricing, proxy evaluation, and Blue/Green deployments. Handles any RDS MySQL, MariaDB, or PostgreSQL question, including create a production-ready RDS MySQL instance, provision an RDS PostgreSQL database, run the RDS upgrade advisor for my RDS MySQL instance, what are my upgrade options, upgrade RDS MariaDB from 10.6 to the latest version, should I buy reserved instances or a savings plan for db.r7g.2xlarge RDS MySQL, change a VARCHAR to INT column on RDS MySQL 8.0 with Blue/Green, and does RDS Proxy help when PgBouncer already runs in transaction mode. Covers instance creation with production best practices, describe-db-instances and describe-db-engine-versions upgrade-target workflow, live prechecks via SSM or direct connection, RI versus DSP commitment pricing, RDS Proxy versus PgBouncer, and Blue/Green lifecycle with binlog replay compatibility.
mouadja02/skills/skills/cloud-aws/migration/dms-schema-conversion Skill
no license9★ repoHandles the full DMS Schema Conversion lifecycle including creating migration projects, converting database schemas to a target engine, running compatibility assessments, navigating metadata trees, exporting converted DDL to S3, applying schema changes to a target database, and converting SQL statements between database engines.
Deploying custom domain rest api
mouadja02/skills/skills/cloud-aws/serverless/deploying-custom-domain-rest-api Skill
no license9★ repoDeploys a Regional REST API with a custom domain name, a Lambda backend function, and a request-based Lambda authorizer using AWS CLI. Covers ACM certificate provisioning, API Gateway REST API creation, Lambda function deployment, request authorizer setup, custom domain configuration, base path mapping, and Route 53 DNS record creation. Trigger keywords: custom domain, REST API, Lambda, Route 53, API Gateway, regional endpoint, request authorizer, base path mapping.
Creating oracle to postgres master migration plan
mouadja02/skills/skills/databases/creating-oracle-to-postgres-master-migration-plan Skill
no license9★ repoDiscovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan
Creating oracle to postgres migration bug report
mouadja02/skills/skills/databases/creating-oracle-to-postgres-migration-bug-report Skill
no license9★ repoCreates structured bug reports for defects found during Oracle-to-PostgreSQL migration
Creating oracle to postgres migration integration tests
mouadja02/skills/skills/databases/creating-oracle-to-postgres-migration-integration-tests Skill
no license9★ repoCreates integration test cases for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Generates DB-agnostic xUnit tests with deterministic seed data that validate behavior consistency across both database systems
mouadja02/skills/skills/databases/database-designer Skill
no license9★ repoDesign and audit relational database schemas
mouadja02/skills/skills/databases/dbt-expert Skill
no license9★ repodbt — models, schema.yml, sources, tests, macros, YAML generation, best practices
mouadja02/skills/skills/databases/etl-to-dbt Skill
no license9★ repoETL/ELT → dbt migration — Informatica/PowerBI mappings, transformation logic, YAML
Migrating oracle to postgres stored procedures
mouadja02/skills/skills/databases/migrating-oracle-to-postgres-stored-procedures Skill
no license9★ repoMigrates Oracle PL/SQL stored procedures to PostgreSQL PL/pgSQL. Translates Oracle-specific syntax, preserves method signatures and type-anchored parameters, leverages orafce where appropriate, and applies COLLATE "C" for Oracle-compatible text sorting. Use when converting Oracle stored procedures or functions to PostgreSQL equivalents during a database migration.
Planning oracle to postgres migration integration testing
mouadja02/skills/skills/databases/planning-oracle-to-postgres-migration-integration-testing Skill
no license9★ repoOracle → PostgreSQL integration test plan for .NET data access artifacts
mouadja02/skills/skills/databases/postgresql-code-review Skill
no license9★ repoPostgreSQL code review — PG-specific best practices, anti-patterns, quality standards
mouadja02/skills/skills/databases/postgresql-optimization Skill
no license9★ repoPostgreSQL optimization — unique features, advanced types, exclusive capabilities
Reviewing oracle to postgres migration
mouadja02/skills/skills/databases/reviewing-oracle-to-postgres-migration Skill
no license9★ repoIdentifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting, timestamps, concurrent transactions, etc.)
Scaffolding oracle to postgres migration test project
mouadja02/skills/skills/databases/scaffolding-oracle-to-postgres-migration-test-project Skill
no license9★ repoScaffolds an xUnit integration test project for validating Oracle-to-PostgreSQL database migration behavior in .NET solutions. Creates the test project, transaction-rollback base class, and seed data manager
mouadja02/skills/skills/databases/snowflake-sql Skill
no license9★ repoSnowflake SQL — QUALIFY, FLATTEN, VARIANT/OBJECT/ARRAY, tasks, streams, stages
mouadja02/skills/skills/databases/sql-code-review Skill
no license9★ repoSQL code review — security, maintainability, quality across all SQL dialects
mouadja02/skills/skills/databases/sql-optimization Skill
no license9★ repoSQL performance optimization — query tuning, indexing, explain plans, all dialects
Sqlite wal checkpoint starvation diagnostics
mouadja02/skills/skills/databases/sqlite-wal-checkpoint-starvation-diagnostics Skill
no license9★ repoUse when a SQLite database in WAL mode has a growing -wal file, repeated incomplete checkpoints, SQLITE_BUSY, disk-pressure risk, or reader slowdowns that may indicate checkpoint starvation.
mouadja02/skills/skills/diagrams-slides/svg-diagrams Skill
no license9★ repoAlso use when the user wants to visualize agent workflows, ETL pipelines, dbt lineage, API flows, or system integrations. If the words diagram, chart, flow, architecture, visualize, or draw appear in a visual context — use this skill
mouadja02/skills/skills/engineering-craft/senior-backend Skill
no license9★ repoDesigns and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening. Use when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review backend code", "set up GraphQL", "handle database migrations", or "load test APIs". Covers Node.js/Express/Fastify development, PostgreSQL optimization, API security, and backend architecture patterns.
The same file is in 3 other repositories
mouadja02/skills/skills/engineering-craft/senior-data-engineer Skill
no license9★ repoData engineering — pipelines, ETL/ELT, Python/SQL/Spark, Airflow, dbt, cloud DWH
mouadja02/skills/skills/engineering-craft/x-twitter-scraper Skill
no license9★ repoBuild GitHub Copilot workflows with Xquik X API SDKs, REST endpoints, MCP tools, signed webhooks, tweet search, user lookup, follower exports, media actions, and agent automation
mouadja02/skills/skills/llm-tooling/openrouter-oauth Skill
no license9★ repoImplement "Sign In with OpenRouter" using OAuth PKCE — framework-agnostic, no SDK or client registration required. Use when the user wants to add OpenRouter login, authentication, sign-in buttons, OAuth, or AI model inference API keys for browser-based apps. No client registration, no backend, no secrets required.
pinkpixel-dev/skills-collection-1/SKILLS/airflow-dag-patterns Skill
9★ repoBuild production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. Use when creating data pipelines, orchestrating workflows, or scheduling batch jobs.
pinkpixel-dev/skills-collection-1/SKILLS/api-documentation-writer Skill
9★ repoGenerate comprehensive API documentation including endpoint descriptions, request/response examples, authentication guides, error codes, and SDKs. Creates OpenAPI/Swagger specs, REST API docs, and developer-friendly reference materials. Use when users need to document APIs, create technical references, or write developer documentation.
pinkpixel-dev/skills-collection-1/SKILLS/api-endpoint-builder Skill
9★ repoBuilds production-ready REST API endpoints with validation, error handling, authentication, and documentation. Follows best practices for security and scalability.
The same file is in 1 other repository
pinkpixel-dev/skills-collection-1/SKILLS/api-security-best-practices Skill
9★ repoImplement secure API design patterns including authentication, authorization, input validation, rate limiting, and protection against common API vulnerabilities
The same file is in 3 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/api-security-testing Skill
9★ repoAPI security testing workflow for REST and GraphQL APIs covering authentication, authorization, rate limiting, input validation, and security best practices.
The same file is in 2 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/apify-ultimate-scraper Skill
9★ repoAI-driven data extraction from 55+ Actors across all major platforms. This skill automatically selects the best Actor for your task.
The same file is in 1 other repository
pinkpixel-dev/skills-collection-1/SKILLS/aspnet-core Skill
9★ repoBuild, review, refactor, or architect ASP.NET Core web applications using current official guidance for .NET web development. Use when working on Blazor Web Apps, Razor Pages, MVC, Minimal APIs, controller-based Web APIs, SignalR, gRPC, middleware, dependency injection, configuration, authentication, authorization, testing, performance, deployment, or ASP.NET Core upgrades.
The same file is in 3 other repositories
Auditing kubernetes cluster rbac
pinkpixel-dev/skills-collection-1/SKILLS/auditing-kubernetes-cluster-rbac Skill
9★ repoAuditing Kubernetes cluster RBAC configurations to identify overly permissive roles, wildcard permissions, dangerous ClusterRoleBindings, service account abuse, and privilege escalation paths using kubectl, rbac-tool, KubiScan, and Kubeaudit.
The same file is in 1 other repository
pinkpixel-dev/skills-collection-1/SKILLS/auth-implementation-patterns Skill
9★ repoBuild secure, scalable authentication and authorization systems using industry-standard patterns and modern best practices.
The same file is in 1 other repository
pinkpixel-dev/skills-collection-1/SKILLS/azure-postgres-ts Skill
9★ repoConnect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.
The same file is in 1 other repository
Azure resource manager mysql dotnet
pinkpixel-dev/skills-collection-1/SKILLS/azure-resource-manager-mysql-dotnet Skill
9★ repoAzure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.
The same file is in 1 other repository
Azure resource manager postgresql dotnet
pinkpixel-dev/skills-collection-1/SKILLS/azure-resource-manager-postgresql-dotnet Skill
9★ repoAzure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments.
The same file is in 1 other repository
Azure resource manager redis dotnet
pinkpixel-dev/skills-collection-1/SKILLS/azure-resource-manager-redis-dotnet Skill
9★ repoAzure Resource Manager SDK for Redis in .NET.
The same file is in 1 other repository
Azure resource manager sql dotnet
pinkpixel-dev/skills-collection-1/SKILLS/azure-resource-manager-sql-dotnet Skill
9★ repoAzure Resource Manager SDK for Azure SQL in .NET.
The same file is in 1 other repository
pinkpixel-dev/skills-collection-1/SKILLS/backend-architect Skill
9★ repoExpert backend architect specializing in scalable API design, microservices architecture, and distributed systems.
The same file is in 2 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/backend-dev-guidelines Skill
9★ repoYou are a senior backend engineer operating production-grade services under strict architectural and reliability constraints. Use when routes, controllers, services, repositories, express middleware, or prisma database access.
The same file is in 1 other repository
Backend development feature development
pinkpixel-dev/skills-collection-1/SKILLS/backend-development-feature-development Skill
9★ repoOrchestrate end-to-end backend feature development from requirements to deployment. Use when coordinating multi-phase feature delivery across teams and services.
The same file is in 3 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/backend-security-coder Skill
9★ repoExpert in secure backend coding practices specializing in input validation, authentication, and API security. Use PROACTIVELY for backend security implementations or security code reviews.
The same file is in 2 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/better-auth/best-practices Skill
9★ repoConfigure Better Auth server and client, set up database adapters, manage sessions, add plugins, and handle environment variables. Use when users mention Better Auth, betterauth, auth.ts, or need to set up TypeScript authentication with email/password, OAuth, or plugin configuration.
The same file is in 3 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/better-auth/create-auth Skill
9★ repoScaffold and implement authentication in TypeScript/JavaScript apps using Better Auth. Detect frameworks, configure database adapters, set up route handlers, add OAuth providers, and create auth UI pages. Use when users want to add login, sign-up, or authentication to a new or existing project with Better Auth.
The same file is in 3 other repositories
pinkpixel-dev/skills-collection-1/SKILLS/better-auth/twoFactor Skill
9★ repoConfigure TOTP authenticator apps, send OTP codes via email/SMS, manage backup codes, handle trusted devices, and implement 2FA sign-in flows using Better Auth's twoFactor plugin. Use when users need MFA, multi-factor authentication, authenticator setup, or login security with Better Auth.
pinkpixel-dev/skills-collection-1/SKILLS/broken-authentication Skill
9★ repoIdentify and exploit authentication and session management vulnerabilities in web applications. Broken authentication consistently ranks in the OWASP Top 10 and can lead to account takeover, identity theft, and unauthorized access to sensitive systems.
The same file is in 7 other repositories
Building identity federation with saml azure ad
pinkpixel-dev/skills-collection-1/SKILLS/building-identity-federation-with-saml-azure-ad Skill
9★ repoEstablish SAML 2.0 identity federation between on-premises Active Directory and Azure AD (Microsoft Entra ID) for seamless cross-domain authentication and SSO to cloud applications.
Building mcp server on cloudflare
pinkpixel-dev/skills-collection-1/SKILLS/building-mcp-server-on-cloudflare Skill
9★ repoBuilds remote MCP (Model Context Protocol) servers on Cloudflare Workers with tools, OAuth authentication, and production deployment. Generates server code, configures auth providers, and deploys to Workers. Use when: user wants to "build MCP server", "create MCP tools", "remote MCP", "deploy MCP", add "OAuth to MCP", or mentions Model Context Protocol on Cloudflare. Also triggers on "MCP authentication" or "MCP deployment". Biases towards retrieval from Cloudflare docs over pre-trained knowledge.
The same file is in 1 other repository
Building role mining for rbac optimization
pinkpixel-dev/skills-collection-1/SKILLS/building-role-mining-for-rbac-optimization Skill
9★ repoApply bottom-up and top-down role mining techniques to discover optimal RBAC roles from existing user-permission assignments, reducing role explosion and enforcing least privilege.