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
lukedj78/dev-flow/rn-backend Skill
4★ repoUse to connect an Expo + RN app to a backend (auth, database, storage, realtime), agnostic of the provider. Teaches the shared patterns: secure-store for tokens, auth state via Zustand + TanStack Query, refresh-on-401 middleware, auth-gate routing via Expo Router (app)/_layout.tsx, row-level security vs API-auth concepts. Provider-specific details live in sub-references: Supabase (default, matches the course), Firebase, custom REST/JSON, tRPC. Triggers on: "setup backend", "setup auth with X", "connect Supabase/Firebase/my API", "secure token storage", "refresh token flow", "row level security". Not for: building the login UI (rn-add-screen — uses Form template), push notifications (rn-push-notifications), payments (rn-publishing-payments).
lukedj78/dev-flow/rn-module-add Skill
4★ repoUse to wire a backend/infra module (auth, db, storage, realtime, push, payments) into a scaffolded Expo + RN app. Reads .workflow/meta.json with stack.framework="expo-rn" and the user-chosen provider for each module (Supabase, Firebase, custom REST, tRPC, RevenueCat). Installs deps, generates the wiring code (lib/auth.ts, lib/supabase.ts, etc.), updates meta.json#stack to record the choice. Always idempotent. Triggers on: "add auth", "wire up db", "set up Supabase", "set up Firebase", "add payments", "add push" (the server-side part), "aggiungi modulo X". Not for: building UI for the module (rn-add-screen does the login screen, etc.), client-side knowledge only (rn-backend, rn-push-notifications), scaffolding (rn-bootstrap).
efeumutaslan/SAP-SKILLS/skills/sap-hana-cloud Skill
4★ repoSAP HANA Cloud database development and administration skill. Use when writing SQLScript procedures, creating calculation views, managing HDI containers, optimizing HANA SQL, using spatial/graph/JSON engines, or configuring data tiering (NSE). If the user mentions HANA Cloud, SQLScript, calculation view, HDI container, or HANA performance tuning, use this skill. Covers QRC 2025+.
efeumutaslan/SAP-SKILLS/skills/sap-security-authorization Skill
4★ repoSAP security, authorization, and compliance skill. Use when designing PFCG roles, analyzing SU53 auth errors, checking SoD conflicts, implementing SOX/GDPR compliance, configuring IAS/IPS/XSUAA, or auditing user access. If the user mentions SAP role, authorization object, SU53, SoD, SAP_ALL, principal propagation, or BTP security, use this skill. Covers on-premise, S/4HANA Cloud, and BTP.
tbc-servicos/dataagile-agent-kit/protheus/skills/fwrest-client-generator Skill
4★ repoGenerate AdvPL/TLPP code that CONSUMES external REST APIs using the FWRest client class. Covers GET, POST, PUT, DELETE verbs, header construction, query/path parameters, JSON body serialization, authentication (No Auth, HTTP Basic, Bearer Token/JWT, OAuth 2.0), timeout, SSL, status code handling, error treatment, and TLPP try/catch patterns. Use when user says 'consume REST API', 'call external API', 'FWRest', 'oRestClient', 'integrate with third-party API', 'HTTP client AdvPL', 'POST JSON Protheus', 'Bearer token AdvPL'.
tbc-servicos/dataagile-agent-kit/protheus/skills/sql-code-review Skill
4★ repoUniversal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across SQL databases (PostgreSQL, SQL Server, Oracle). Focuses on SQL injection prevention, access control, code standards, and anti-pattern detection. Complements SQL optimization prompt for complete development coverage. Use when user says "review SQL", "SQL security audit", "SQL anti-patterns", "check SQL quality".
tbc-servicos/dataagile-agent-kit/protheus/skills/sql-optimization Skill
4★ repoUniversal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across SQL databases (PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance. Use when user says "optimize SQL", "slow query", "index strategy", "execution plan analysis".
tbc-servicos/dataagile-agent-kit/protheus/skills/sql Skill
4★ repoReferência e geração de SQL embarcado em ADVPL/TLPP para Protheus. Cobre BeginSQL/EndSQL, macros essenciais (%table%, %xfilial%, %notDel%, %exp%, %Order%), TCSqlExec para INSERT/UPDATE/DELETE, joins, subconsultas e anti-patterns de segurança.
tbc-servicos/dataagile-agent-kit/protheus/skills/tlpp-rest-endpoint-generator Skill
4★ repoGenerate TLPP REST endpoints using annotation-based routing (@Get, @Post, @Put, @Patch, @Delete) with the oRest object. Follows TOTVS API standards (TTALK) including pagination, error model, standard headers, and Swagger documentation. Use when user says 'create REST endpoint', 'TLPP REST', '@Get annotation', 'oRest endpoint'.
yasserstudio/perfex-crm-skills/skills/perfex-database Skill
4★ repoUse whenever the user writes SQL DDL for a Perfex CRM module, adds a foreign key referencing `tblcontacts`, `tblstaff`, `tblclients`, `tblinvoices`, or any `tbl*` core table, designs `tbl<module>_<entity>` schema, writes `install.php` / `uninstall.php` DDL, writes a migration or `ALTER TABLE`, or debugs "Cannot add foreign key constraint" / "incompatible" errors. Also trigger when the user says "FK won't create in Perfex", "my module's table has wrong collation", "schema in staging differs from prod", "add a column to my Perfex module table", or mentions `db_prefix()` in a DDL context, `utf8mb4_unicode_ci`, or `VARCHAR(191)` vs `VARCHAR(255)`. Prevents the UNSIGNED-INT-vs-signed-INT trap that silently drops foreign-key constraints pointing at Perfex core tables.
yasserstudio/perfex-crm-skills/skills/perfex-security Skill
4★ repoUse whenever a Perfex CRM task touches security-sensitive code — issuing or consuming single-use tokens (password reset, magic link, confirmation), race-safe atomic UPDATE with `affected_rows()` check, handling user-controlled redirect URLs (`?next=`, `?redirect=`, `?return_to=`), rate-limiting an AJAX endpoint that leaks boolean state, cross-module model loads, logging PII, adding `target="_blank"` links, or excluding a webhook from CSRF. Also trigger when the user says "my magic link works twice", "password reset is racy", "someone can enumerate users by email", "open redirect in my module", "CSRF blocking my webhook", "rate limit this endpoint", or mentions "TOCTOU", "enumeration", `html_purify`, or `app_generate_hash()`. Every rule here exists because its absence caused a real Perfex production incident.
celigo/ai/skills/writing-sql Skill
4★ repoWrite SQL queries for Celigo RDBMS exports and imports -- SELECT, INSERT, UPDATE, UPSERT, MERGE, delta, once, and bulk operations across Snowflake, Postgres, MySQL, SQL Server, Oracle, BigQuery, and Redshift. Use when editing rdbms.query or troubleshooting SQL errors.
mathisk2095/jko-claude-plugins/plugins/python-backend/skills/python-backend-expert Skill
3★ repoThis skill should be used when the user is writing, reviewing, debugging, or architecting Python backend code using Litestar or FastAPI with SQLAlchemy or Advanced Alchemy. Provides expert critique covering SOLID principles, hexagonal architecture, repository/service patterns, dependency injection, async correctness, ORM usage, API design, anti-pattern detection, and modern Python patterns for mature production backends. Use when the user asks "critique my Python backend", "review this controller", "fix my SQLAlchemy query", "structure my project", "is this SOLID", "review my repository", "optimize my API", "design my service layer", "help with dependency injection", "set up a Litestar project", "set up a FastAPI project", "create a repository pattern", "fix my async code", "review my database models", or "fix N+1 query".
carlopezzuto/agents/.claude/skills/auth-implementation-patterns Skill
3★ 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.
carlopezzuto/agents/.claude/skills/fastapi-templates Skill
3★ 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.
QBall-Inc/clear/skills/session-management Skill
3★ repoUse when PERFORMING session actions: checking token usage, preparing handoffs, or ending sessions early. Do NOT load for questions about past sessions or reading historical handoff documents.
lantisprime/claude-sdlc/skills/security-review Skill
3★ repoUse this skill to review code changes for security concerns before they merge. Covers input validation, authentication and authorization, secrets handling, injection surfaces (SQL, command, template, prompt), unsafe APIs and dependencies, sensitive data handling, and output encoding. Runs against the current diff (NOT the whole codebase) so findings stay relevant to the change at hand. Trigger proactively whenever the diff touches auth, routing, data access, user input, template rendering, external calls, or dependency files. Also runs as part of the /review and /ship commands.
aneja5/forge-skills/skills/database-design Skill
3★ repoUse when designing a new schema, writing a migration, adding or auditing indexes, reviewing query performance, choosing between hard delete and soft delete, or establishing database conventions for a project.
ProjAnvil/MindForge/skills/zh-cn/database-design Skill
3★ repo数据库设计和优化技能,涵盖 ER 图、规范化、索引、分片、查询优化和数据库最佳实践。使用此技能设计数据库架构、优化查询、规划数据架构,或需要数据库扩展和性能调优指导时使用。
bethanychamberlain/claude-skills-librechat/librechat-ops/skills/infrastructure Skill
3★ repoUse when configuring LibreChat's MongoDB database, Redis caching, MeiliSearch message search, file storage strategy (local vs CDN/S3), or PGVector for RAG. Also use when asked about database backup, connection strings, or storage scaling.
bethanychamberlain/claude-skills-librechat/librechat-security/skills/auth Skill
3★ repoUse when configuring LibreChat authentication: setting up OAuth2/OIDC providers (Azure AD, Google, GitHub, Keycloak, Auth0), configuring SAML, setting up LDAP, enabling social logins, configuring email verification, or integrating with institutional identity providers. Also use when SSO or login is not working.
edfenton/claude-skills/mern/mern-add-auth Skill
3★ repoAdd authentication to a MERN project using NextAuth.js with OAuth and/or credentials.
edfenton/claude-skills/nean/nean-add-auth Skill
3★ repoAdd authentication to a NEAN project using Passport.js with JWT and optional OAuth.
CODE-SAURABH/OpenSkills/api-design Skill
3★ repoDesign production-grade APIs — REST, GraphQL, gRPC, and WebSocket — with a focus on consistency, versioning, error standards, and developer experience. Use when the user asks to design an API, define endpoints, choose between REST and GraphQL, structure request/response schemas, handle API versioning, design pagination, or produce an OpenAPI/Swagger spec.
CODE-SAURABH/OpenSkills/backend-dev Skill
3★ repoProduction-grade backend development guidance — language and framework agnostic. Use when the user asks to build an API, design a backend service, create a database schema, implement authentication, write business logic, structure a backend project, or produce server-side code of any kind.
CODE-SAURABH/OpenSkills/data-engineer Skill
3★ repoDesign and build production-grade data pipelines, ETL/ELT workflows, data warehouses, and streaming architectures. Use when the user asks about data pipelines, ETL/ELT, dbt models, Airflow DAGs, Kafka, data warehouses (Snowflake, BigQuery, Redshift), data quality, schema design for analytics, event streaming, or says "build a pipeline", "transform this data", or "set up a data warehouse".
CODE-SAURABH/OpenSkills/database-architect Skill
3★ repoExpert database architecture and design guidance — schema/data modeling, ER diagrams, indexing, query optimization, partitioning, replication and high availability, transactions and locking, connection pooling, migrations, and multi-tenancy patterns across PostgreSQL, MySQL, MongoDB, and Redis. Use this whenever the user asks about designing a schema, a slow or N+1 query, choosing between SQL and NoSQL, sharding, read replicas, a database migration, or says something like "why is this query slow" or "how should I structure this table" — even without the word "database" in the request.
CODE-SAURABH/OpenSkills/security-engineer Skill
3★ repoExpert application and infrastructure security guidance. Use when the user asks about OWASP Top 10, JWT review, RBAC, OAuth, threat modeling, SSRF, CSRF, XSS, or secret management.
MuhammedZohaib/patchman/plugins/patchman/skills/query-review Skill
3★ repoReview an authorized codebase for ORM misuse, N+1 query patterns, authorization-after-fetch bugs, raw SQL risks, cache key collisions, and missing tenant scopes. Use for data-access layers and security-adjacent performance pitfalls.
MuhammedZohaib/patchman/skills/api-review Skill
3★ repoReview an authorized API surface for access control, mass assignment, schema validation, rate limiting, SSRF, error leakage, webhook verification, and unsafe defaults. Use for REST, GraphQL, RPC, and webhook handlers.
MuhammedZohaib/patchman/skills/auth-review Skill
3★ repoPerform a defensive review of authentication and authorization flows in an authorized codebase. Use for login, session, MFA, OAuth, password reset, cookie security, JWT validation, impersonation, privilege checks, and object-level access control.
MuhammedZohaib/patchman/skills/query-review Skill
3★ repoReview an authorized codebase for ORM misuse, N+1 query patterns, authorization-after-fetch bugs, raw SQL risks, cache key collisions, and missing tenant scopes. Use for data-access layers and security-adjacent performance pitfalls.
VersoXBT/claude-recommended-skills/data-fetch-analysis Skill
3★ repoConnect to databases, monitoring systems, analytics platforms, and APIs to fetch, analyze, and report on data. Use when the user says 'query the database', 'check the metrics', 'fetch data from', 'analyze this data', 'pull logs', 'generate a report', 'check error rates', 'what does the data show', 'dashboard data', or 'investigate this trend'. Also triggers on 'data analysis', 'database query', 'monitoring data', 'log analysis', 'metrics investigation', 'data pipeline', 'data fetching', 'SQL query', or 'run a query'.
soden46/syarif-laravel-ai-skills/skills/policies-and-authorization Skill
3★ repoLaravel guidance to enforce access via Policies and Gates; use authorize() and authorizeResource() to standardize controller protections
soden46/syarif-laravel-ai-skills/skills/rate-limiting Skill
3★ repoLaravel guidance to apply per-user and per-route limits with RateLimiter and throttle middleware; use backoffs and headers for clients
Pranjay-kumar/universal-data-acquisition-pipeline-skill/skills/data-acquisition-discovery Skill
3★ repoUse for discovering and reverse-engineering data sources: official APIs, XHR/fetch, GraphQL, persisted queries, Algolia, Shopify, Salesforce Commerce Cloud, sitemaps, feeds, embedded JSON, hydration state, page-data routes, pagination limits, headers, params, and endpoint templates.
Rootx202/appsec-skills/backend-security Skill
no license3★ repoBackend/server-side security auditor for Node.js, Express, NestJS, FastAPI, Django, Flask, Spring, Ruby on Rails, and similar frameworks. Use when reviewing server-side application logic, error handling, logging, file upload handling, or general middleware configuration specifically — separate from database or API-contract concerns.
Rootx202/appsec-skills/database-security Skill
no license3★ repoDatabase security auditor covering PostgreSQL, MySQL, SQL Server, MongoDB, and Supabase/Firebase-style backends. Use when the user asks about database security, Row Level Security (RLS) policies, exposed database access, ORM-related SQL injection, or backend-as-a-service data access rules for any project.
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-api-platform-builder/api-endpoint-builder Skill
3★ 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 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-api-platform-builder/api-security-best-practices Skill
3★ repoImplement secure API design patterns including authentication, authorization, input validation, rate limiting, and protection against common API vulnerabilities
The same file is in 4 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-data-analytics/database-architect Skill
3★ repoExpert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures.
The same file is in 7 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-data-analytics/postgres-best-practices Skill
3★ repoPostgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
The same file is in 4 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-data-analytics/sql-pro Skill
3★ repoMaster modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.
The same file is in 4 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-documents-presentations/google-docs-automation Skill
3★ repoLightweight Google Docs integration with standalone OAuth authentication. No MCP server required.
The same file is in 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-documents-presentations/google-sheets-automation Skill
3★ repoLightweight Google Sheets integration with standalone OAuth authentication. No MCP server required. Full read/write access.
The same file is in 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-documents-presentations/google-slides-automation Skill
3★ repoLightweight Google Slides integration with standalone OAuth authentication. No MCP server required. Full read/write access.
The same file is in 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-python-api-builder/fastapi-templates Skill
3★ 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.
The same file is in 7 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-secure-app-builder/backend-security-coder Skill
3★ 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 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-secure-app-builder/broken-authentication Skill
3★ 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
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-secure-app-builder/cc-skill-security-review Skill
3★ repoThis skill ensures all code follows security best practices and identifies potential vulnerabilities. Use when implementing authentication or authorization, handling user input or file uploads, or creating new API endpoints.
The same file is in 4 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-secure-app-builder/sql-injection-testing Skill
3★ repoExecute comprehensive SQL injection vulnerability assessments on web applications to identify database security flaws, demonstrate exploitation techniques, and validate input sanitization mechanisms.
The same file is in 3 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/aas-security-engineer/api-security-testing Skill
3★ 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 6 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/full-stack-developer/backend-dev-guidelines Skill
3★ 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 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/integration-apis/hubspot-integration Skill
3★ repoExpert patterns for HubSpot CRM integration including OAuth authentication, CRM objects, associations, batch operations, webhooks, and custom objects. Covers Node.js and Python SDKs.
The same file is in 7 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/revops-crm-automation/google-calendar-automation Skill
3★ repoLightweight Google Calendar integration with standalone OAuth authentication. No MCP server required.
The same file is in 7 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/uncategorized/apify-ultimate-scraper Skill
3★ 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 5 other repositories
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/uncategorized/azure-postgres-ts Skill
3★ repoConnect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.
The same file is in 7 other repositories
Azure resource manager mysql dotnet
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/uncategorized/azure-resource-manager-mysql-dotnet Skill
3★ repoAzure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments.
The same file is in 4 other repositories
Azure resource manager postgresql dotnet
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/uncategorized/azure-resource-manager-postgresql-dotnet Skill
3★ repoAzure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments.
The same file is in 4 other repositories
Azure resource manager redis dotnet
LiHongwei-cn/lihongwei-cn/mundo-cloud/skills/uncategorized/azure-resource-manager-redis-dotnet Skill
3★ repoAzure Resource Manager SDK for Redis in .NET.
The same file is in 7 other repositories