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
Amey-Thakur/AI-SKILLS/skills/big-tech-roles/backend-engineer-role Skill
14★ repoOperate as a backend engineer who designs stable API contracts, guards data integrity, and ships services that are operable on day one. Use when building or reviewing a service, API, or data path and you want production-grade engineering discipline.
Amey-Thakur/AI-SKILLS/skills/data-engineering/data-pipeline-design Skill
14★ repoBuild data pipelines that rerun safely, backfill cleanly, and tolerate late data. Use when designing batch or streaming pipelines or fixing ones that need manual babysitting.
Amey-Thakur/AI-SKILLS/skills/data-engineering/etl-vs-elt Skill
14★ repoPlace transformations before or after loading based on warehouse economics, governance, and reuse. Use when architecting a data platform or deciding where a transformation should live.
Amey-Thakur/AI-SKILLS/skills/databases/database-migrations Skill
14★ repoChange schemas safely with expand-contract, online DDL, batched backfills, and rollback awareness. Use when altering a production schema or when a migration risks locking or downtime.
Amey-Thakur/AI-SKILLS/skills/databases/database-normalization Skill
14★ repoApply normal forms pragmatically and denormalize deliberately, weighing update anomalies against read performance. Use when designing a relational schema or deciding whether to denormalize.
Amey-Thakur/AI-SKILLS/skills/databases/orm-tradeoffs Skill
14★ repoUse ORMs for their productivity while avoiding N+1 queries and knowing when to drop to raw SQL. Use when working with an ORM or debugging the performance problems ORMs quietly cause.
Amey-Thakur/AI-SKILLS/skills/databases/sql-optimization Skill
14★ repoDiagnose and fix slow SQL with the query plan as evidence, not folklore. Use when a query is slow, a table scan appears, or database load climbs.
Amey-Thakur/AI-SKILLS/skills/javascript-typescript/node-backend-setup Skill
14★ repoBootstrap a Node.js backend with ESM, typed config, graceful shutdown, and structured logging from the start. Use when starting a Node service or hardening one that grew without foundations.
Amey-Thakur/AI-SKILLS/skills/performance/n-plus-one-queries Skill
14★ repoFind and eliminate N+1 database access where one query per row replaces one query for the set, using eager loading, batching, or a dataloader. Use when a list endpoint is slow, query counts scale with result size, or an ORM lazy-loads inside a loop.
Amey-Thakur/AI-SKILLS/skills/security/api-security Skill
14★ repoSecure an API by enforcing per-object authorization, per-caller quota, and schema-validated input on every endpoint. Use when building or reviewing an HTTP or GraphQL API that serves authenticated users, machine clients, or partner integrations.
Amey-Thakur/AI-SKILLS/skills/security/audit-logging Skill
14★ repoRecord security-relevant events in a tamper-evident, append-only log that answers who did what and when. Use when building or reviewing logging for authentication, authorization, privilege changes, or access to sensitive data.
Amey-Thakur/AI-SKILLS/skills/security/jwt-handling Skill
14★ repoUse JSON Web Tokens safely by pinning the algorithm, keeping lifetimes short, and pairing them with a revocation path. Use when issuing or validating JWTs, designing a session scheme around them, or reviewing token-based auth.
Amey-Thakur/AI-SKILLS/skills/security/oauth-flows Skill
14★ repoImplement OAuth 2.0 and OpenID Connect flows that bind the request end to end with PKCE, state, and exact redirect allowlists. Use when adding "sign in with" a provider, integrating a third-party API on a user's behalf, or reviewing an OAuth client.
Amey-Thakur/AI-SKILLS/skills/security/rate-limiting Skill
14★ repoLimit requests by the cost they impose and the identity behind them, using token buckets, deliberate keys, and tiered responses to abuse. Use when protecting an API, a login flow, or any expensive endpoint from brute force, scraping, and accidental overload.
Amey-Thakur/AI-SKILLS/skills/security/session-management Skill
14★ repoHandle sessions so identifiers rotate on privilege change, expire on inactivity, can be revoked server-side, and ride only on hardened cookies. Use when issuing, storing, or validating session tokens after a user signs in.
Amey-Thakur/AI-SKILLS/skills/security/sql-injection-defense Skill
14★ repoEliminate SQL injection by sending data as bound parameters instead of concatenated query text, and auditing every raw-SQL escape hatch. Use when writing or reviewing code that builds database queries from variables.
Amey-Thakur/AI-SKILLS/skills/testing/database-testing Skill
14★ repoExercise data-access code, migrations, and transactions against the real database engine so constraints, rollbacks, and schema changes are proven rather than assumed. Use when tests for queries or migrations run on SQLite while production runs Postgres.
ngocsangyem/MeowKit/.claude/skills/api-design Skill
14★ repoREST/GraphQL API design: resource naming, HTTP methods, status codes, pagination, versioning, error formats. Use for 'design API', 'endpoint patterns'.
ngocsangyem/MeowKit/.claude/skills/database Skill
14★ repoDatabase patterns: schema design, migrations, query optimization, indexing. PostgreSQL primary. Use for 'database schema', 'migration', 'SQL optimization'.
ngocsangyem/MeowKit/packages/mewkit/src/migrate/modules/codex/root/.agents/skills/mk-api-design Skill
14★ repoREST/GraphQL API design: resource naming, HTTP methods, status codes, pagination, versioning, error formats. Use for 'design API', 'endpoint patterns'.
ngocsangyem/MeowKit/packages/mewkit/src/migrate/modules/codex/root/.agents/skills/mk-database Skill
14★ repoDatabase patterns: schema design, migrations, query optimization, indexing. PostgreSQL primary. Use for 'database schema', 'migration', 'SQL optimization'.
ngocsangyem/MeowKit/packages/mewkit/src/migrate/modules/cursor/root/.cursor/skills/mk-api-design Skill
14★ repoREST/GraphQL API design: resource naming, HTTP methods, status codes, pagination, versioning, error formats. Use for 'design API', 'endpoint patterns'.
ngocsangyem/MeowKit/packages/mewkit/src/migrate/modules/cursor/root/.cursor/skills/mk-database Skill
14★ repoDatabase patterns: schema design, migrations, query optimization, indexing. PostgreSQL primary. Use for 'database schema', 'migration', 'SQL optimization'.
Shoebtamboli/rails_claude_skills/lib/generators/claude/skills_library/rails-api-controllers Skill
14★ repoRESTful API controller patterns for Ruby on Rails. Use when: (1) Building JSON APIs, (2) API versioning, (3) Error handling and status codes, (4) Authentication with tokens/JWT, (5) Rate limiting, (6) CORS configuration, (7) Pagination and filtering, (8) API documentation, (9) Testing API endpoints
Shoebtamboli/rails_claude_skills/lib/generators/claude/skills_library/rails-authorization-cancancan Skill
14★ repoAuthorization and permissions management for Ruby on Rails applications using CanCanCan. Use when: (1) Implementing role-based access control (RBAC), (2) Defining user permissions and abilities, (3) Restricting resource access in controllers, (4) Filtering queries based on user permissions, (5) Hiding/showing UI elements based on authorization, (6) Testing authorization logic, (7) Managing admin vs user vs guest permissions, (8) Implementing attribute-based access control
rahmanef63/si-coder-agent/skills/sc-stripe Skill
14★ repo(STUB / NOT IMPLEMENTED YET) Stripe payments setup — create products/prices, webhook endpoint registration, customer portal config, restricted API keys. Pairs with sc-convex for `payments` table mutations and HTTP webhook routes.
aborroy/aiup-alfresco/.cursor/skills/permission-model-validator Skill
14★ repoValidates custom Alfresco permission model XML for well-formedness, no collision with built-in permission group names, correct permissionSet binding, and that any dynamic authority is registered and implements DynamicAuthority. Trigger automatically after generating or editing a *permissionDefinitions.xml or a *DynamicAuthority.java file.
aborroy/aiup-alfresco/.cursor/skills/rest-api-validator Skill
14★ repoValidates Alfresco v1 Public REST API resources for correct annotations (@EntityResource / @RelationshipResource), required @WebApiDescription on every action method, a single @UniqueId on the model POJO, paged collection returns, and absence of classic Web Script anti-patterns. Trigger automatically after generating or editing files under a rest/ package or any class annotated @EntityResource / @RelationshipResource.
aborroy/aiup-alfresco/.cursor/skills/rest-api Skill
14★ repoGenerate a modern ACS v1 Public REST API resource (annotation-based @EntityResource / @RelationshipResource with @WebApiDescription) plus model POJO, Spring registration, and unit test. In-Process SDK (Maven) only.
aborroy/aiup-alfresco/skills/permission-model-validator Skill
14★ repoValidates custom Alfresco permission model XML for well-formedness, no collision with built-in permission group names, correct permissionSet binding, and that any dynamic authority is registered and implements DynamicAuthority. Trigger automatically after generating or editing a *permissionDefinitions.xml or a *DynamicAuthority.java file.
aborroy/aiup-alfresco/skills/rest-api-validator Skill
14★ repoValidates Alfresco v1 Public REST API resources for correct annotations (@EntityResource / @RelationshipResource), required @WebApiDescription on every action method, a single @UniqueId on the model POJO, paged collection returns, and absence of classic Web Script anti-patterns. Trigger automatically after generating or editing files under a rest/ package or any class annotated @EntityResource / @RelationshipResource.
jpmorgan-payments/pdp-skills/skills/jpm-oauth Skill
14★ repoImplement J.P. Morgan Payments OAuth authentication (JWT signing + IDAnywhere token exchange) in a merchant project. Use this skill when a merchant has their clientId, certificate, private key, and SHA-1 thumbprint and wants to generate the auth code in their codebase — typically right after running jpm-integrations-get-started. Produces a language-specific auth module with built-in token caching that follows JPM guidance against regenerating tokens per request. Supports Node/TypeScript, Python, and Java idiomatically; for other languages, translates from the canonical algorithm. Asks for target environment (CAT or PROD) and JWT TTL (default 6 months for CAT, 8h for PROD per JPM guidance); the resource_id is read from the merchant's `.env` at runtime rather than collected interactively.
marcioaltoe/claude-craftkit/plugins/db-tools/skills/database-architect Skill
14★ repoExpert database schema designer and Drizzle ORM specialist. Use when user needs database design, schema creation, migrations, query optimization, or Postgres-specific features. Examples - "design a database schema for users", "create a Drizzle table for products", "help with database relationships", "optimize this query", "add indexes to improve performance", "design database for multi-tenant app".
krutikJain/android-agent-skills/.github/skills/android-room-database Skill
14★ repoModel Room entities, DAOs, transactions, migrations, schema exports, and test-safe local persistence.
krutikJain/android-agent-skills/skills/android-room-database Skill
14★ repoModel Room entities, DAOs, transactions, migrations, schema exports, and test-safe local persistence.
onfire7777/universal-ai-skills-library/skill-router-cli/cmd/skills/testdata/route-fixture/skills/crawl4ai Skill
14★ repoUse when working with unclecode/crawl4ai or the local Crawl4AI stack: installing, updating, setting up, diagnosing, or using the `crwl` CLI for LLM-ready web crawling, scraping, Markdown extraction, JSON extraction, deep crawling, browser profiles, CDP browser control, screenshots/PDF/MHTML export, or Python `AsyncWebCrawler` workflows. Prefer this for deterministic local web-to-Markdown and crawler workflows. Do not use for generic web search when the host AI has native search.
onfire7777/universal-ai-skills-library/skill-router-cli/cmd/skills/testdata/route-fixture/skills/sql-injection-testing Skill
14★ repoThis skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "extract database information through injection", "detect SQL injection flaws", or "exploit database query vulnerabilities". It provides comprehensive techniques for identifying, exploiting, and understanding SQL injection attack vectors across different database systems.
onfire7777/universal-ai-skills-library/skills/api-design Skill
14★ repoREST API design patterns including resource naming, status codes, pagination, filtering, error responses, versioning, and rate limiting for production APIs.
The same file is in 2 other repositories
onfire7777/universal-ai-skills-library/skills/apify-automation Skill
14★ repoAutomate web scraping and data extraction with Apify -- run Actors, manage datasets, create reusable tasks, and retrieve crawl results through the Composio Apify integration.
onfire7777/universal-ai-skills-library/skills/auth-implementation-patterns Skill
14★ repoMaster authentication and authorization patterns including JWT, OAuth2, session management, and RBAC to build secure, scalable access control systems. Use when implementing auth systems, securing APIs, or debugging security issues.
onfire7777/universal-ai-skills-library/skills/backend-patterns Skill
14★ repoBackend architecture patterns, API design, database optimization, and server-side best practices for Node.js, Express, and Next.js API routes.
The same file is in 2 other repositories
onfire7777/universal-ai-skills-library/skills/bright-data-best-practices Skill
14★ repoBuild production-ready Bright Data integrations with best practices baked in. Reference documentation for developers using coding assistants (Claude Code, Cursor, etc.) to implement web scraping, search, browser automation, and structured data extraction. Covers Web Unlocker API, SERP API, Web Scraper API, and Browser API (Scraping Browser).
onfire7777/universal-ai-skills-library/skills/browser-automation Skill
14★ repoBrowser automation powers web testing, scraping, and AI agent interactions. The difference between a flaky script and a reliable system comes down to understanding selectors, waiting strategies, and anti-detection patterns. This skill covers Playwright (recommended) and Puppeteer, with patterns for testing, scraping, and agentic browser control. Key insight: Playwright won the framework war. Unless you need Puppeteer's stealth ecosystem or are Chrome-only, Playwright is the better choice in 202
onfire7777/universal-ai-skills-library/skills/cf-crawl Skill
14★ repoCrawl entire websites using Cloudflare Browser Rendering /crawl API. Initiates async crawl jobs, polls for completion, and saves results as markdown files. Useful for ingesting documentation sites, knowledge bases, or any web content into your project context. Requires CLOUDFLARE_ACCOUNT_ID and CLOUDFLARE_API_TOKEN environment variables.
onfire7777/universal-ai-skills-library/skills/code-security Skill
14★ repoSecurity guidelines for writing secure code. Use when writing code, reviewing code for vulnerabilities, or asking about secure coding practices like 'check for SQL injection' or 'review security'. IMPORTANT: Always consult this skill when writing or reviewing any code that handles user input, authentication, file operations, database queries, network requests, cryptography, or infrastructure configuration (Terraform, Kubernetes, Docker, GitHub Actions) — even if the user doesn't explicitly mention security. Also use when users ask to 'review my code', 'check this for bugs', or 'is this safe'.
Conducting api security testing
onfire7777/universal-ai-skills-library/skills/conducting-api-security-testing Skill
14★ repoConducts security testing of REST, GraphQL, and gRPC APIs to identify vulnerabilities in authentication, authorization, rate limiting, input validation, and business logic. The tester uses the OWASP API Security Top 10 as the testing framework, combining Burp Suite interception with Postman collections and custom scripts to test endpoint security at every privilege level. Activates for requests involving API security testing, REST API pentest, GraphQL security assessment, or API vulnerability testing.
Configuring oauth2 authorization flow
onfire7777/universal-ai-skills-library/skills/configuring-oauth2-authorization-flow Skill
14★ repoConfigure secure OAuth 2.0 authorization flows including Authorization Code with PKCE, Client Credentials, and Device Authorization Grant. This skill covers flow selection, PKCE implementation, token
onfire7777/universal-ai-skills-library/skills/contentful-graphql-automation Skill
14★ repoAutomate Contentful Graphql tasks via Rube MCP (Composio). Always search tools first for current schemas.
The same file is in 6 other repositories
onfire7777/universal-ai-skills-library/skills/crawl4ai Skill
14★ repoUse when working with unclecode/crawl4ai or the local Crawl4AI stack: installing, updating, setting up, diagnosing, or using the `crwl` CLI for LLM-ready web crawling, scraping, Markdown extraction, JSON extraction, deep crawling, browser profiles, CDP browser control, screenshots/PDF/MHTML export, or Python `AsyncWebCrawler` workflows. Prefer this for deterministic local web-to-Markdown and crawler workflows. Do not use for generic web search when the host AI has native search.
onfire7777/universal-ai-skills-library/skills/detecting-oauth-token-theft Skill
14★ repoDetects and responds to OAuth token theft and replay attacks in cloud environments, focusing on Microsoft Entra ID (Azure AD) token protection, conditional access policies, and sign-in anomaly detection. Covers access token theft, refresh token replay, Primary Refresh Token (PRT) abuse, and pass-the-cookie attacks. Activates for requests involving OAuth token theft detection, token replay prevention, Azure AD conditional access token protection, or cloud identity attack investigation.
Detecting sql injection via waf logs
onfire7777/universal-ai-skills-library/skills/detecting-sql-injection-via-waf-logs Skill
14★ repoAnalyze WAF (ModSecurity/AWS WAF/Cloudflare) logs to detect SQL injection attack campaigns. Parses ModSecurity audit logs and JSON WAF event logs to identify SQLi patterns (UNION SELECT, OR 1=1, SLEEP(), BENCHMARK()), tracks attack sources, correlates multi-stage injection attempts, and generates incident reports with OWASP classification.
onfire7777/universal-ai-skills-library/skills/fastapi-endpoint Skill
14★ repoPlan and build production-ready FastAPI endpoints with async SQLAlchemy, Pydantic v2 models, dependency injection for auth, and pytest tests. Uses interview-driven planning to clarify data models, authentication method, pagination strategy, and caching before writing any code.
onfire7777/universal-ai-skills-library/skills/fastapi-templates Skill
14★ repoCreate production-ready FastAPI projects with async patterns, dependency injection, and comprehensive error handling. Use when building new FastAPI applications or setting up backend API projects.
onfire7777/universal-ai-skills-library/skills/firecrawl-automation Skill
14★ 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.
onfire7777/universal-ai-skills-library/skills/firecrawl-scraper Skill
14★ repoDeep web scraping, screenshots, PDF parsing, and website crawling using Firecrawl API
Implementing api rate limiting and throttling
onfire7777/universal-ai-skills-library/skills/implementing-api-rate-limiting-and-throttling Skill
14★ repoImplements API rate limiting and throttling controls using token bucket, sliding window, and fixed window algorithms to protect against brute force attacks, credential stuffing, resource exhaustion, and API abuse. The engineer configures per-user, per-IP, and per-endpoint rate limits using Redis-backed counters, API gateway plugins, or application middleware, and implements proper HTTP 429 responses with Retry-After headers. Activates for requests involving rate limiting implementation, API throttling setup, request quota management, or API abuse prevention.
Implementing endpoint detection with wazuh
onfire7777/universal-ai-skills-library/skills/implementing-endpoint-detection-with-wazuh Skill
14★ repoDeploy and configure Wazuh SIEM/XDR for endpoint detection including agent management, custom decoder and rule XML creation, alert querying via the Wazuh REST API, and automated response actions.
onfire7777/universal-ai-skills-library/skills/lightpanda-browser Skill
14★ repoUse when an AI skill, MCP client, or automation needs browser-based web retrieval, JavaScript page loading, scraping, form interaction, markdown extraction, semantic DOM extraction, or Playwright/Puppeteer CDP automation without graphical rendering. Defaults AI browser work to Lightpanda on this machine.
onfire7777/universal-ai-skills-library/skills/mssql Skill
14★ repoExecute read-only SQL queries against multiple Microsoft SQL Server databases. Use when: (1) querying MSSQL/SQL Server databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
onfire7777/universal-ai-skills-library/skills/mysql Skill
14★ repoExecute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.