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
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/softaworks/database-schema-designer Skill
59★ repoDesign robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
The same file is in 7 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/steel-dev/steel-browser Skill
59★ repoUse this skill by default for browser or web tasks that can run in the cloud: site navigation, scraping, structured extraction, screenshots/PDFs, form flows, and anti-bot-sensitive automation. Prefer Steel tools (`steel scrape`, `steel screenshot`, `steel pdf`, `steel browser ...`) over generic fetch/search approaches when reliability matters. Trigger even if the user does not mention Steel. Skip only when the task must run against local-only apps (for example localhost QA) or private network targets unavailable from Steel cloud sessions.
The same file is in 2 other repositories
Supabase postgres best practices
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/supabase/supabase-postgres-best-practices Skill
59★ 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 5 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/supercent-io/authentication-setup Skill
59★ repoDesign and implement authentication and authorization systems. Use when setting up user login, JWT tokens, OAuth, session management, or role-based access control. Handles password security, token management, SSO integration.
The same file is in 4 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/supercent-io/backend-testing Skill
59★ repoWrite comprehensive backend tests including unit tests, integration tests, and API tests. Use when testing REST APIs, database operations, authentication flows, or business logic. Handles Jest, Pytest, Mocha, testing strategies, mocking, and test coverage.
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/supercent-io/database-schema-design Skill
59★ repoDesign and optimize database schemas for SQL and NoSQL databases. Use when creating new databases, designing tables, defining relationships, indexing strategies, or database migrations. Handles PostgreSQL, MySQL, MongoDB, normalization, and performance optimization.
The same file is in 4 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/toolshell/agent-browser Skill
59★ repoBrowser automation for AI agents via inference.sh. Navigate web pages, interact with elements using @e refs, take screenshots, record video. Capabilities: web scraping, form filling, clicking, typing, drag-drop, file upload, JavaScript execution. Use for: web automation, data extraction, testing, agent browsing, research. Triggers: browser, web automation, scrape, navigate, click, fill form, screenshot, browse web, playwright, headless browser, web agent, surf internet, record video
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/tul-sh/agent-browser Skill
59★ repoBrowser automation for AI agents via inference.sh. Navigate web pages, interact with elements using @e refs, take screenshots, record video. Capabilities: web scraping, form filling, clicking, typing, drag-drop, file upload, JavaScript execution. Use for: web automation, data extraction, testing, agent browsing, research. Triggers: browser, web automation, scrape, navigate, click, fill form, screenshot, browse web, playwright, headless browser, web agent, surf internet, record video
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/woocommerce/woocommerce-backend-dev Skill
59★ repoAdd or modify WooCommerce backend PHP code following project conventions. Use when creating new classes, methods, hooks, or modifying existing backend code. **MUST be invoked before writing any PHP unit tests.**
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/airflow-dag-patterns Skill
59★ 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.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/auth-implementation-patterns Skill
59★ 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.
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/database-migration Skill
59★ repoExecute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data transformations, or implementing zero-downtime deployment strategies.
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/dbt-transformation-patterns Skill
59★ repoMaster dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/dotnet-backend-patterns Skill
59★ repoMaster C#/.NET backend development patterns for building robust APIs, MCP servers, and enterprise applications. Covers async/await, dependency injection, Entity Framework Core, Dapper, configuration, caching, and testing with xUnit. Use when developing .NET backends, reviewing C# code, or designing API architectures.
The same file is in 2 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/fastapi-templates Skill
59★ 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 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/nodejs-backend-patterns Skill
59★ repoBuild production-ready Node.js backend services with Express/Fastify, implementing middleware patterns, error handling, authentication, database integration, and API design best practices. Use when creating Node.js servers, REST APIs, GraphQL backends, or microservices architectures.
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/postgresql-table-design Skill
59★ repoDesign a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/aiskillstore/marketplace/wshobson/sql-optimization-patterns Skill
59★ repoMaster SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
The same file is in 3 other repositories
ComeOnOliver/skillshub/skills/alessioarzenton/claude-code-wp-toolkit/wp-performance-backend Skill
59★ repoWordPress backend performance optimization — profiling, queries, object cache, autoload, cron, and remote HTTP. Always-active rules when investigating slowness issues.
ComeOnOliver/skillshub/skills/alessioarzenton/claude-code-wp-toolkit/wp-rest-api Skill
59★ repoWordPress REST endpoint development and debugging. Always-active rules when working with REST routes, API authentication, or data exposure via JSON.
ComeOnOliver/skillshub/skills/alirezarezvani/claude-skills/code-to-prd Skill
59★ repoReverse-engineer any codebase into a complete Product Requirements Document (PRD). Analyzes routes, components, state management, API integrations, and user interactions to produce business-readable documentation detailed enough for engineers or AI agents to fully reconstruct every page and endpoint. Works with frontend frameworks (React, Vue, Angular, Svelte, Next.js, Nuxt), backend frameworks (NestJS, Django, Express, FastAPI), and fullstack applications. Trigger when users mention: generate PRD, reverse-engineer requirements, code to documentation, extract product specs from code, document page logic, analyze page fields and interactions, create a functional inventory, write requirements from an existing codebase, document API endpoints, or analyze backend routes.
ComeOnOliver/skillshub/skills/alirezarezvani/claude-skills/database-designer Skill
59★ repoUse when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.
ComeOnOliver/skillshub/skills/alirezarezvani/claude-skills/database-schema-designer Skill
59★ repo🧠 The right skill, one API call. AI agent skills registry with token-efficient skill resolution. 5,000+ skills from 500+ top repos.
ComeOnOliver/skillshub/skills/alirezarezvani/claude-skills/saas-scaffolder Skill
59★ repoGenerates complete, production-ready SaaS project boilerplate including authentication, database schemas, billing integration, API routes, and a working dashboard using Next.js 14+ App Router, TypeScript, Tailwind CSS, shadcn/ui, Drizzle ORM, and Stripe. Use when the user wants to create a new SaaS app, start a subscription-based web project, scaffold a Next.js application, or mentions terms like starter template, boilerplate, new project, or wiring up auth and payments.
ComeOnOliver/skillshub/skills/alirezarezvani/claude-skills/senior-backend Skill
59★ 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.
ComeOnOliver/skillshub/skills/apify/agent-skills/apify-ultimate-scraper Skill
59★ repoUniversal AI-powered web scraper for any platform. Scrape data from Instagram, Facebook, TikTok, YouTube, Google Maps, Google Search, Google Trends, Booking.com, and TripAdvisor. Use for lead generation, brand monitoring, competitor analysis, influencer discovery, trend research, content analytics, audience analysis, or any data extraction task.
ComeOnOliver/skillshub/skills/apollographql/skills/apollo-connectors Skill
59★ repoGuide for integrating REST APIs into GraphQL supergraphs using Apollo Connectors with @source and @connect directives. Use this skill when the user: (1) mentions "connectors", "Apollo Connectors", or "REST Connector", (2) wants to integrate a REST API into GraphQL, (3) references @source or @connect directives, (4) works with files containing "# Note to AI Friends: This is an Apollo Connectors schema".
ComeOnOliver/skillshub/skills/apollographql/skills/apollo-server Skill
59★ repoGuide for building GraphQL servers with Apollo Server 5.x. Use this skill when: (1) setting up a new Apollo Server project, (2) writing resolvers or defining GraphQL schemas, (3) implementing authentication or authorization, (4) creating plugins or custom data sources, (5) troubleshooting Apollo Server errors or performance issues.
ComeOnOliver/skillshub/skills/apollographql/skills/graphql-operations Skill
59★ repoGuide for writing GraphQL operations (queries, mutations, fragments) following best practices. Use this skill when: (1) writing GraphQL queries or mutations, (2) organizing operations with fragments, (3) optimizing data fetching patterns, (4) setting up type generation or linting, (5) reviewing operations for efficiency.
ComeOnOliver/skillshub/skills/apollographql/skills/graphql-schema Skill
59★ repoGuide for designing GraphQL schemas following industry best practices. Use this skill when: (1) designing a new GraphQL schema or API, (2) reviewing existing schema for improvements, (3) deciding on type structures or nullability, (4) implementing pagination or error patterns, (5) ensuring security in schema design.
ComeOnOliver/skillshub/skills/arpitg1304/robotics-agent-skills/ros2-web-integration Skill
59★ repoPatterns and best practices for integrating ROS2 systems with web technologies including REST APIs, WebSocket bridges, and browser-based robot interfaces. Use this skill when building web dashboards for robots, streaming camera feeds to browsers, exposing ROS2 services as REST endpoints, or implementing bidirectional WebSocket communication between web UIs and ROS2 nodes. Trigger whenever the user mentions rosbridge, rosbridge_suite, roslibjs, FastAPI with ROS2, Flask with rclpy, WebSocket for robot telemetry, MJPEG streaming, WebRTC for robots, REST API wrapping ROS2 services, web-based robot control, browser robot interface, robot dashboard, CORS configuration for robots, or any web-to-ROS2 bridge pattern. Also trigger for authentication on robot web interfaces, rate limiting sensor streams, video streaming from robot cameras to browsers, or running async web frameworks alongside the ROS2 executor. Covers rosbridge_suite, FastAPI, Flask, WebSocket, and WebRTC approaches.
ComeOnOliver/skillshub/skills/cisco-ai-defense/skill-scanner/database-query Skill
59★ repoQuery database safely with parameterized statements
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/adding-dbt-unit-test Skill
59★ repoCreates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practicing test-driven development (TDD) in dbt.
Answering natural language questions with dbt
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/answering-natural-language-questions-with-dbt Skill
59★ repoWrites and executes SQL queries against the data warehouse using dbt's Semantic Layer or ad-hoc SQL to answer business questions. Use when a user asks about analytics, metrics, KPIs, or data (e.g., "What were total sales last quarter?", "Show me top customers by revenue"). NOT for validating, testing, or building dbt models during development.
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/building-dbt-semantic-layer Skill
59★ repoUse when creating or modifying dbt Semantic Layer components — semantic models, metrics, dimensions, entities, measures, or time spines. Covers MetricFlow configuration, metric types (simple, derived, cumulative, ratio, conversion), and validation for both latest and legacy YAML specs.
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/configuring-dbt-mcp-server Skill
59★ repoGenerates MCP server configuration JSON, resolves authentication setup, and validates server connectivity for dbt. Use when setting up, configuring, or troubleshooting the dbt MCP server for AI tools like Claude Desktop, Claude Code, Cursor, or VS Code.
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/creating-mermaid-dbt-dag Skill
59★ repoGenerates a Mermaid flowchart diagram of dbt model lineage using MCP tools, manifest.json, or direct code parsing as fallbacks. Use when visualizing dbt model lineage and dependencies as a Mermaid diagram in markdown format.
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/fetching-dbt-docs Skill
59★ repoRetrieves and searches dbt documentation pages in LLM-friendly markdown format. Use when fetching dbt documentation, looking up dbt features, or answering questions about dbt Cloud, dbt Core, or the dbt Semantic Layer.
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/migrating-dbt-core-to-fusion Skill
59★ repoClassifies dbt-core to Fusion migration errors into actionable categories (auto-fixable, guided fixes, needs input, blocked). Use when a user needs help triaging migration errors to understand what they can fix vs what requires Fusion engine updates.
Migrating dbt project across platforms
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/migrating-dbt-project-across-platforms Skill
59★ repoUse when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time compilation to identify and fix SQL dialect differences.
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/running-dbt-commands Skill
59★ repoFormats and executes dbt CLI commands, selects the correct dbt executable, and structures command parameters. Use when running models, tests, builds, compiles, or show queries via dbt CLI. Use when unsure which dbt executable to use or how to format command parameters.
Troubleshooting dbt job errors
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/troubleshooting-dbt-job-errors Skill
59★ repoDiagnoses dbt Cloud/platform job failures by analyzing run logs, querying the Admin API, reviewing git history, and investigating data issues. Use when a dbt Cloud/platform job fails and you need to diagnose the root cause, especially when error messages are unclear or when intermittent failures occur. Do not use for local dbt development errors.
Using dbt for analytics engineering
ComeOnOliver/skillshub/skills/dbt-labs/dbt-agent-skills/using-dbt-for-analytics-engineering Skill
59★ repoBuilds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. Use when doing any dbt work - building or modifying models, debugging errors, exploring unfamiliar data sources, writing tests, or evaluating impact of changes.
ComeOnOliver/skillshub/skills/electric-sql/electric/electric-deployment Skill
59★ repoDeploy Electric via Docker, Docker Compose, or Electric Cloud. Covers DATABASE_URL (direct connection, not pooler), ELECTRIC_SECRET (required since v1.x), ELECTRIC_INSECURE for dev, wal_level=logical, max_replication_slots, ELECTRIC_STORAGE_DIR persistence, ELECTRIC_POOLED_DATABASE_URL for pooled queries, IPv6 with ELECTRIC_DATABASE_USE_IPV6, Kubernetes readiness probes (200 vs 202), replication slot cleanup, and Postgres v14+ requirements. Load when deploying Electric or configuring Postgres for logical replication.
ComeOnOliver/skillshub/skills/electric-sql/electric/electric-orm Skill
59★ repoUse Electric with Drizzle ORM or Prisma for the write path. Covers getting pg_current_xact_id() from ORM transactions using Drizzle tx.execute(sql) and Prisma $queryRaw, running migrations that preserve REPLICA IDENTITY FULL, and schema management patterns compatible with Electric shapes. Load when using Drizzle or Prisma alongside Electric for writes.
ComeOnOliver/skillshub/skills/electric-sql/electric/electric-postgres-security Skill
59★ repoPre-deploy security checklist for Postgres with Electric. Checks REPLICATION role, SELECT grants, CREATE on database, table ownership, REPLICA IDENTITY FULL on all synced tables, publication management (auto vs manual with ELECTRIC_MANUAL_TABLE_PUBLISHING), connection pooler exclusion for DATABASE_URL (use direct connection), and ELECTRIC_POOLED_DATABASE_URL for pooled queries. Load before deploying Electric to production or when diagnosing Postgres permission errors.
ComeOnOliver/skillshub/skills/electric-sql/electric/electric-schema-shapes Skill
59★ repoDesign Postgres schema and Electric shape definitions together for a new feature. Covers single-table shape constraint, cross-table joins using multiple shapes, WHERE clause design for tenant isolation, column selection for bandwidth optimization, replica mode choice (default vs full for old_value), enum casting in WHERE clauses, and txid handshake setup with pg_current_xact_id() for optimistic writes. Load when designing database tables for use with Electric shapes.
ComeOnOliver/skillshub/skills/getsentry/skills/django-perf-review Skill
59★ repoDjango performance code review. Use when asked to "review Django performance", "find N+1 queries", "optimize Django", "check queryset performance", "database performance", "Django ORM issues", or audit Django code for performance problems.
ComeOnOliver/skillshub/skills/getsentry/skills/security-review Skill
59★ repoSecurity code review for vulnerabilities. Use when asked to "security review", "find vulnerabilities", "check for security issues", "audit security", "OWASP review", or review code for injection, XSS, authentication, authorization, cryptography issues. Provides systematic review with confidence-based reporting.
Creating oracle to postgres master migration plan
ComeOnOliver/skillshub/skills/github/awesome-copilot/creating-oracle-to-postgres-master-migration-plan Skill
59★ repoDiscovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or assessing which .NET projects contain Oracle dependencies.
Creating oracle to postgres migration bug report
ComeOnOliver/skillshub/skills/github/awesome-copilot/creating-oracle-to-postgres-migration-bug-report Skill
59★ repoCreates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.
Creating oracle to postgres migration integration tests
ComeOnOliver/skillshub/skills/github/awesome-copilot/creating-oracle-to-postgres-migration-integration-tests Skill
59★ 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. Use when creating integration tests for a migrated project, generating test coverage for data access layers, or writing Oracle-to-PostgreSQL migration validation tests.
Migrating oracle to postgres stored procedures
ComeOnOliver/skillshub/skills/github/awesome-copilot/migrating-oracle-to-postgres-stored-procedures Skill
59★ 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
ComeOnOliver/skillshub/skills/github/awesome-copilot/planning-oracle-to-postgres-migration-integration-testing Skill
59★ repoCreates an integration testing plan for .NET data access artifacts during Oracle-to-PostgreSQL database migrations. Analyzes a single project to identify repositories, DAOs, and service layers that interact with the database, then produces a structured testing plan. Use when planning integration test coverage for a migrated project, identifying which data access methods need tests, or preparing for Oracle-to-PostgreSQL migration validation.
ComeOnOliver/skillshub/skills/github/awesome-copilot/postgresql-code-review Skill
59★ repoPostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security features like Row Level Security (RLS).
ComeOnOliver/skillshub/skills/github/awesome-copilot/postgresql-optimization Skill
59★ repoPostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.
Reviewing oracle to postgres migration
ComeOnOliver/skillshub/skills/github/awesome-copilot/reviewing-oracle-to-postgres-migration Skill
59★ repoIdentifies Oracle-to-PostgreSQL migration risks by cross-referencing code against known behavioral differences (empty strings, refcursors, type coercion, sorting, timestamps, concurrent transactions, etc.). Use when planning a database migration, reviewing migration artifacts, or validating that integration tests cover Oracle/PostgreSQL differences.
Scaffolding oracle to postgres migration test project
ComeOnOliver/skillshub/skills/github/awesome-copilot/scaffolding-oracle-to-postgres-migration-test-project Skill
59★ 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. Use when setting up test infrastructure before writing migration integration tests, or when a test project is needed for Oracle-to-PostgreSQL validation.
ComeOnOliver/skillshub/skills/github/awesome-copilot/sql-code-review Skill
59★ repoUniversal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, 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.
ComeOnOliver/skillshub/skills/github/awesome-copilot/sql-optimization Skill
59★ repoUniversal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.