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
PramodDutta/qaskills/seed-skills/authorization-testing Skill
201★ repoRole-based and attribute-based access control testing including permission matrices, privilege escalation prevention, and resource-level authorization.
PramodDutta/qaskills/seed-skills/contract-testing-graphql Skill
201★ repoContract testing for GraphQL APIs including schema breaking change detection, query compatibility testing, and federated schema validation.
PramodDutta/qaskills/seed-skills/data-pipeline-testing Skill
201★ repoTesting data pipelines including ETL validation, data quality checks, pipeline orchestration testing, and data lineage verification.
Database migration test generator
PramodDutta/qaskills/seed-skills/database-migration-test-generator Skill
201★ repoGenerate tests for database migration safety covering schema changes, data integrity preservation, rollback verification, and zero-downtime migration validation
PramodDutta/qaskills/seed-skills/database-migration-testing Skill
201★ repoTesting database migration scripts for correctness, rollback safety, data integrity, and zero-downtime migration patterns.
PramodDutta/qaskills/seed-skills/database-performance-testing Skill
201★ repoDatabase performance testing including query optimization, index analysis, connection pooling, slow query detection, and N+1 query prevention.
PramodDutta/qaskills/seed-skills/drizzle-orm-testing Skill
201★ repoTesting patterns for Drizzle ORM covering migration testing, query builder testing, transaction testing, and database integration testing with PostgreSQL, SQLite, and MySQL.
PramodDutta/qaskills/seed-skills/end-to-end-database Skill
201★ repoEnd-to-end database testing with test containers, data seeding, cleanup strategies, transaction isolation, and production data anonymization.
PramodDutta/qaskills/seed-skills/fastapi-testing Skill
201★ repoFastAPI application testing with TestClient, dependency injection overrides, async testing, database testing with SQLAlchemy, and OpenAPI validation.
PramodDutta/qaskills/seed-skills/graphql-subscription-testing Skill
201★ repoTesting GraphQL subscriptions including WebSocket lifecycle, real-time event delivery, authorization on subscriptions, and connection management.
PramodDutta/qaskills/seed-skills/graphql-testing Skill
201★ repoComprehensive GraphQL API testing including query/mutation testing, schema validation, resolver testing, subscription testing, and N+1 query detection.
PramodDutta/qaskills/seed-skills/grpc-testing Skill
201★ repogRPC service testing including protobuf validation, streaming tests, error handling, deadline testing, and load testing for gRPC endpoints.
PramodDutta/qaskills/seed-skills/jwt-security-testing Skill
201★ repoComprehensive JWT token security testing including signature verification, expiration checks, algorithm confusion attacks, and claim validation.
PramodDutta/qaskills/seed-skills/kafka-event-driven-testing Skill
201★ repoTest Kafka-based event-driven systems, producer and consumer integration tests with Testcontainers, schema compatibility gates, idempotency and ordering verification, dead-letter handling, and end-to-end event flow assertions.
PramodDutta/qaskills/seed-skills/mongodb-testing Skill
201★ repoMongoDB testing with in-memory MongoDB, aggregation pipeline testing, schema validation, indexing verification, and replica set testing.
PramodDutta/qaskills/seed-skills/n-plus-one-query-detector Skill
201★ repoDetect and eliminate N+1 query problems in database-backed applications through query counting, execution plan analysis, and ORM configuration auditing
PramodDutta/qaskills/seed-skills/owasp-security Skill
201★ repoSecurity testing skill based on OWASP Top 10, covering ZAP scanning, security headers, input validation, authentication, and authorization testing.
PramodDutta/qaskills/seed-skills/puppeteer-automation Skill
201★ repoAutomate Chrome with Puppeteer for scraping, screenshots, PDF generation, and E2E checks — correct launch options, reliable waiting with locators and waitForSelector, request interception, and headless CI execution.
PramodDutta/qaskills/seed-skills/puppeteer-testing Skill
201★ repoComprehensive Puppeteer browser automation and testing skill for headless Chrome scripting, web scraping, PDF generation, network interception, and end-to-end test workflows in JavaScript and TypeScript.
PramodDutta/qaskills/seed-skills/redis-testing Skill
201★ repoRedis testing including cache behavior verification, pub/sub testing, transaction testing, cluster failover testing, and data expiration validation.
PramodDutta/qaskills/seed-skills/sql-injection-testing Skill
201★ repoComprehensive SQL injection testing patterns including blind SQLi, time-based, union-based, and parameterized query validation techniques.
PramodDutta/qaskills/seed-skills/testcontainers-reuse-node Skill
201★ repoTeaches the agent to speed up Node integration tests with Testcontainers reuse — withReuse(true), TESTCONTAINERS_REUSE_ENABLE, the .testcontainers.properties opt-in, stable hashing for Postgres/MySQL/Kafka, and Ryuk/CI caveats.
PramodDutta/qaskills/seed-skills/webhook-testing Skill
201★ repoTesting webhook implementations including delivery verification, retry logic, signature validation, idempotency, and failure handling patterns.
Dynatrace/dynatrace-for-ai/skills/dt-obs-azure Skill
181★ repoAzure cloud resources including VMs, VMSS, SQL Database, Storage, AKS, App Service, Functions, VNet networking, load balancers, Event Hubs, Container Apps, and Key Vault. Monitor Azure infrastructure, analyze resource usage, audit security posture, and manage organizational hierarchy across subscriptions and resource groups.
The same file is in 9 other repositories
techygarg/lattice/skills/atoms/secure-coding Skill
179★ repoApply security-conscious thinking when generating or modifying code. Enforces trust boundary awareness, input validation, injection prevention, secrets management, and defense-in-depth authorization. Use when generating code that handles user input, authentication, authorization, database queries, external APIs, file operations, or when the user mentions 'security review', 'secure this', 'check for vulnerabilities', 'trust boundary', 'input validation', or 'OWASP'. This skill governs the security posture of generated code -- not architecture (see architecture) and not code craft (see clean-code).
The same file is in 1 other repository
techygarg/lattice/plugins/lattice/skills/secure-coding Skill
176★ repoApply security-conscious thinking when generating or modifying code. Enforces trust boundary awareness, input validation, injection prevention, secrets management, and defense-in-depth authorization. Use when generating code that handles user input, authentication, authorization, database queries, external APIs, file operations, or when the user mentions 'security review', 'secure this', 'check for vulnerabilities', 'trust boundary', 'input validation', or 'OWASP'. This skill governs the security posture of generated code -- not architecture (see architecture) and not code craft (see clean-code).
redis/agent-skills/skills/redis-connections Skill
172★ repoRedis client and connection guidance covering connection pooling, multiplexing, pipelining, client-side caching with RESP3, avoiding slow commands (KEYS, SMEMBERS, HGETALL), and tuning socket timeouts. Use when configuring a Redis client (redis-py, Jedis, Lettuce, NRedisStack), batching commands for throughput, eliminating per-request connection creation, iterating large keyspaces with SCAN, enabling client-side caching for read-heavy workloads, or setting connect and read timeouts.
The same file is in 11 other repositories
redis/agent-skills/skills/redis-core Skill
172★ repoCore Redis modeling guidance — choose the right data structure (String, Hash, List, Set, Sorted Set, JSON, Stream, Vector Set) and use consistent colon-separated key names. Use when designing a Redis data model, caching objects, deciding between Hash and JSON, building counters, leaderboards, membership sets, or session stores, or when reviewing/cleaning up Redis key naming.
The same file is in 18 other repositories
redis/agent-skills/skills/redis-observability Skill
172★ repoRedis observability guidance — which metrics to monitor (memory, connections, hit ratio, ops/sec, rejected connections), which built-in commands to reach for during incident triage (SLOWLOG, INFO, MEMORY DOCTOR, CLIENT LIST, FT.PROFILE), and when to use the Redis Insight GUI. Use when setting up monitoring or alerts for a Redis instance, diagnosing a performance regression, profiling a slow FT.SEARCH query, or wiring Redis metrics into Prometheus, Datadog, or similar.
The same file is in 11 other repositories
redis/agent-skills/skills/redis-search Skill
172★ repoRedis Search guidance covering FT.CREATE schema design, field type selection (TEXT, TAG, NUMERIC, GEO, GEOSHAPE, VECTOR, JSON path), DIALECT 2 query syntax, FT.SEARCH / FT.AGGREGATE / FT.HYBRID command selection, vector similarity with HNSW or FLAT, hybrid retrieval combining lexical and vector ranking, RAG pipelines, zero-downtime index updates via aliases, and debugging with FT.PROFILE and FT.EXPLAIN. Use when defining a search index on Hash or JSON documents, writing FT.SEARCH queries with filters, sorting, aggregation, or vector KNN, tuning HNSW parameters, building a RAG retrieval pipeline, or troubleshooting slow or empty search results.
The same file is in 5 other repositories
redis/agent-skills/skills/redis-security Skill
172★ repoRedis security guidance covering authentication (requirepass and ACL users), TLS, ACL-based least-privilege access control, restricting network exposure via bind and protected-mode, firewall rules, and disabling dangerous commands. Use when deploying Redis to production, defining ACL users for an application, configuring TLS connections, locking down a Redis instance behind a firewall, or auditing a Redis deployment for security hardening.
The same file is in 12 other repositories
redis/agent-skills/skills/redis-semantic-cache Skill
172★ repoRedis LangCache guidance for semantic caching of LLM responses on Redis Cloud — calling search/set via the SDK or REST API, tuning the similarity threshold, separating caches per task type, and filtering with custom attributes. Use when caching LLM completions or RAG answers to cut API cost and latency, building a cache-aside layer in front of OpenAI / Anthropic / etc., tuning hit rate vs precision, or splitting one app's LLM workloads into multiple LangCache caches.
The same file is in 9 other repositories
magnus919/agent-skills/backend-engineering Skill
169★ repoBackend engineering methodology — API implementation patterns (REST, gRPC, GraphQL), service architecture (clean/hexagonal/layered), database access patterns, integration and middleware design, error handling, and service-level testing. Language and framework agnostic.
magnus919/agent-skills/bundles/tailscale/skills/headscale-backup Skill
169★ repoBackup, restore, and migrate Headscale installations — SQLite database, configuration file, policy file, and TLS certificates. Use when backing up a headscale server before upgrades, migrating to new hardware, or restoring from a disaster.
magnus919/agent-skills/data-engineering Skill
169★ repoData engineering methodology — database operations (vector, relational, graph, time-series), ETL/ELT pipeline design (dbt patterns, incremental loading), SQL analytical patterns, data quality monitoring, schema migration, and storage infrastructure management. Grounded in operational patterns for production data systems.
magnus919/agent-skills/fireflies Skill
169★ repoQuery Fireflies.ai meeting transcripts, meeting notes, summaries, contacts, channels, AI meeting analytics, AskFred, audio uploads, and webhook signatures through its GraphQL API. Use when a user mentions Fireflies, Fireflies.ai, meeting transcripts or notes stored in Fireflies, AskFred, or Fireflies webhooks. Do not use for local audio transcription, calendar management, or meetings that are not Fireflies data.
magnus919/agent-skills/secure-software-engineering Skill
169★ repoUse when designing or implementing software securely: define security requirements, threat-model a feature, choose secure defaults, design authentication and authorization, handle untrusted data and secrets, evaluate dependencies, or review security-sensitive changes. Use for prevention during requirements, design, implementation, and review; not for post-build security assessments or scanning an existing codebase.
magnus919/agent-skills/supabase Skill
169★ repoUse this skill when developing applications with Supabase, running the Supabase CLI, designing migrations and RLS policies, testing database behavior, generating client types, deploying the official self-hosted Docker stack, or administering its Postgres, Auth, Storage, Realtime, Functions, API gateway, backups, upgrades, and security. Use it for managed and self-hosted projects. Do not use it for generic PostgreSQL work with no Supabase services or conventions.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/core/frappe-core-api Skill
no license167★ repoUse when building ERPNext/Frappe API integrations (v14/v15/v16) including REST API, RPC API, authentication, webhooks, and rate limiting. Covers external API calls, endpoint design, token/OAuth2/session authentication. Keywords: API integration, REST endpoint, webhook, token authentication,, how to connect, external API, send data to another system, API not working, 401 error. OAuth, frappe.call, external connection, rate limiting.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/core/frappe-core-database Skill
no license167★ repoUse when performing database operations in ERPNext/Frappe v14-v16. Covers frappe.db methods, ORM patterns (frappe.get_doc, frappe.get_list), raw SQL, caching patterns, and performance optimization. Prevents common mistakes with database transactions and query building. Keywords: frappe.db, frappe.get_doc, database query, SQL, ORM, caching, database performance, query returns nothing, slow database, how to fetch data, get document by name, frappe.get_list empty.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/errors/frappe-errors-api Skill
no license167★ repoUse when debugging or handling API errors in Frappe/ERPNext v14/v15/v16. Prevents silent failures and wrong HTTP status codes in REST endpoints. Covers 401 Unauthorized (wrong token format, expired OAuth), 403 Forbidden (missing @whitelist, allow_guest needed), 404 Not Found (wrong endpoint URL), 417 Expectation Failed (validation via frappe.throw), 500 Internal Server Error, CORS issues, CSRF token missing/invalid, rate limit exceeded (429), file upload failures, JSON parse errors in request/response, webhook delivery failures, and timeout on long operations. Keywords: API error, 401, 403, 404, 417, 429, 500, CSRF, CORS, REST,, API call fails, 403 forbidden, CORS error, token expired, endpoint not found, webhook not received. whitelist, webhook, rate limit, file upload, authentication token.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/errors/frappe-errors-database Skill
no license167★ repoUse when handling database errors in Frappe/ERPNext. Covers DuplicateEntryError, LinkValidationError, MandatoryError, TimestampMismatchError, CharacterLengthExceededError, InReadOnlyMode, QueryTimeoutError, SQL injection errors, frappe.db.sql parameter format (% vs %s), get_value returning None, transaction deadlocks, MariaDB gone away, too many connections. Error-to-fix mapping for v14/v15/v16. Keywords: database error, DuplicateEntryError, TimestampMismatchError,, MariaDB error, MySQL error, column not found, table missing, duplicate entry, database crash. SQL injection, deadlock, MariaDB gone away, query timeout.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/impl/frappe-impl-integrations Skill
no license167★ repoUse when implementing OAuth providers, Connected Apps, Webhooks, Payment Gateways, or Data Import/Export in Frappe. Prevents authentication failures from wrong OAuth flow, missed webhook deliveries, and data corruption during bulk imports. Covers OAuth2 provider/client, Connected App DocType, Webhook DocType, Payment Gateway integration, Data Import, Data Export, frappe.integrations module. Keywords: OAuth, Connected App, Webhook, Payment Gateway, Data Import, Data Export, integration, API key, OAuth2, webhook trigger, connect to external service, OAuth setup, webhook configuration, import data, export data..
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/impl/frappe-impl-whitelisted Skill
no license167★ repoUse when building API endpoints with @frappe.whitelist() in Frappe. Covers endpoint design, permission patterns, error handling, client integration, file uploads, background jobs, rate limiting, REST API testing, and migration from Server Scripts to whitelisted methods. Prevents permission bypasses, SQL injection, and data exposure. Keywords: how to create API, build REST endpoint, frappe.call,, create API endpoint, call from frontend, custom API, REST endpoint, how to call python from JS. frappe.whitelist, API permission, guest API, secure endpoint, rate limiting, curl testing, frm.call.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/syntax/frappe-syntax-query-builder Skill
no license167★ repoUse when building database queries with frappe.qb in Frappe v14-v16. Covers the PyPika-based query builder: SELECT, INSERT, UPDATE, DELETE, joins, aggregation, subqueries, cross-DB compatibility (MariaDB/PostgreSQL), and migration from raw SQL. Prevents SQL injection and DB-specific bugs. Keywords: frappe.qb, query builder, DocType, Field, pypika, join,, frappe.qb example, how to write query, join tables, SQL replacement, parameterized query. aggregate, ImportMapper, cross-database, parameterized query.
Impertio-Studio/Frappe_Claude_Skill_Package/skills/source/syntax/frappe-syntax-whitelisted Skill
no license167★ repoUse when creating Frappe Whitelisted Methods (Python API endpoints) for v14/v15/v16. Covers @frappe.whitelist() decorator, frappe.call/frm.call invocations, permission checks, error handling, response formats, and client-server communication. Keywords: whitelisted, API endpoint, frappe.call, frm.call, REST API, @frappe.whitelist, allow_guest, API endpoint example, frappe.whitelist syntax, how to expose function.
TabooHarmony/roblox-brain/skills/roblox-oauth Skill
166★ repoUse when implementing Roblox OAuth 2.0 for Open Cloud, including app registration, PKCE, token exchange, refresh, revocation, or scopes.
EXboys/evotown/backend/arena_skills/database-query Skill
no license157★ repo通过 Evotown Database MCP Proxy 对已注册的业务数据库执行只读 SQL 查询。当用户需要查 CRM、订单、报表等结构化数据时使用;禁止直连数据库或写入 SQL。
w95/awesome-claude-corporate-skills/10-data-analytics/postgres Skill
150★ repoExecute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL 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.
The same file is in 1 other repository
w95/awesome-claude-corporate-skills/10-data-analytics/sql-queries Skill
150★ repoWrite correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.
sendaifun/skills/skills/wallet-analysis Skill
126★ repoAnalyze Solana wallets and multichain portfolios with Zerion API. Use for Solana portfolio value, token positions, transaction history, wallet charts, and PnL. Prefer direct REST API integration, with hosted MCP and x402 on Solana as no-key alternatives for agent workflows.
AltimateAI/data-engineering-skills/skills/dbt/debugging-dbt-errors Skill
120★ repoDebugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error", "broken", "failing", "debug", "wrong", or "not working" (2) Compilation Error, Database Error, or test failures occur (3) Model produces incorrect output or unexpected results (4) Need to troubleshoot why a dbt command failed Reads full error, checks upstream first, runs dbt build (not just compile) to verify fix.
The same file is in 4 other repositories
AltimateAI/data-engineering-skills/skills/dbt/documenting-dbt-models Skill
120★ repoDocuments dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model descriptions or column definitions to schema.yml (2) Task mentions "document", "describe", "description", "dbt docs", or "schema.yml" (3) Explaining business context, grain, meaning of data, or business rules (4) Preparing dbt docs generate or improving model discoverability Matches existing project documentation style and conventions before writing.
The same file is in 4 other repositories
AltimateAI/data-engineering-skills/skills/dbt/migrating-sql-to-dbt Skill
120★ repoConverts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views, or raw SQL files to dbt models (2) Task mentions "migrate", "convert", "legacy SQL", "transform to dbt", or "modernize" (3) Breaking monolithic queries into modular layers (discovers project conventions first) (4) Porting existing data pipelines or ETL to dbt patterns Checks for existing models/sources, builds and validates layer by layer.
The same file is in 4 other repositories
AltimateAI/data-engineering-skills/skills/dbt/refactoring-dbt-models Skill
120★ repoSafely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions "refactor", "restructure", "extract", "split", "break into", or "reorganize" (2) Extracting CTEs to intermediate models or creating macros (3) Modifying model logic that has downstream consumers (4) Renaming columns, changing types, or reorganizing model dependencies Analyzes all downstream dependencies BEFORE making changes.
The same file is in 4 other repositories
AltimateAI/data-engineering-skills/skills/dbt/testing-dbt-models Skill
120★ repoAdds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or modifying tests in schema.yml files (2) Task mentions "test", "validate", "data quality", "unique", "not_null", or "accepted_values" (3) Ensuring data integrity - primary keys, foreign keys, relationships (4) Debugging test failures or understanding why dbt test failed Matches existing project test patterns and YAML style before adding new tests.
The same file is in 4 other repositories
itseffi/agentic-os/.agents/skills/backend-design Skill
120★ repoDesign backend architecture for implementation with API contracts, data model changes, service boundaries, security, and observability.
aAAaqwq/AGI-Super-Team/skills/api-design-patterns Skill
120★ repoComprehensive API design patterns covering REST, GraphQL, gRPC, versioning, authentication, and modern API best practices
The same file is in 9 other repositories
aAAaqwq/AGI-Super-Team/skills/api-design Skill
120★ 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 11 other repositories
aAAaqwq/AGI-Super-Team/skills/api-gateway Skill
120★ repoPassthrough proxy for direct access to third-party APIs using managed OAuth connections, provided by [Maton](https://maton.ai). The API gateway lets y Connect to 100+ APIs (Google Workspace, Microsoft 365, GitHub, Notion, Slack, Airtable, HubSpot, etc.) with managed OAuth. Use this skill when users want to interact with external services. Security: The MATON_API_KEY authenticates with Maton.ai but grants NO access to third-party services by itself. Each service requires explicit OAuth authorization by the user through Maton's connect flow. Access is strictly scoped to connections the user has authorized. Provided by Maton (https://maton.ai).
The same file is in 1 other repository