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
matejformanek/postgres-claude/.claude/skills/replication-overview Skill
2★ repoHack or review PostgreSQL replication internals — covers physical streaming, archive shipping, logical decoding, logical replication PUB/SUB, and synchronous-commit machinery. Names walsender / walreceiver / replication slot / output plugin callbacks plus the relevant GUCs (wal_level, max_wal_senders, max_replication_slots, max_logical_replication_workers, primary_conninfo, primary_slot_name, synchronous_standby_names) and the source files behind each flavor. Use whenever a PG patch touches walsender, walreceiver, replication slots, logical decoding, output plugins, publications/subscriptions, conflict detection, sync replication, failover slots, pg_basebackup, or pg_receivewal — or when picking which mechanism fits a feature design. Skip for MySQL row-based / GTID replication, MongoDB replica sets, Cassandra hinted handoff, Kafka MirrorMaker / Confluent Replicator, Debezium / Flink CDC pipelines, AWS DMS, and Galera / Group Replication.
matejformanek/postgres-claude/.claude/skills/row-level-security Skill
2★ repoPostgreSQL's Row-Level Security (RLS) — `CREATE POLICY` / `ALTER TABLE ... ENABLE ROW LEVEL SECURITY` / policy application in the rewriter — plus the related security-barrier machinery + leakproof qualification checks. Loads when the user asks about RLS policy semantics (USING vs WITH CHECK, PERMISSIVE vs RESTRICTIVE), how policies are applied to a query at rewrite time, why a qual can/cannot be pushed below a security barrier, the leakproof function attribute, ROLE mapping for BYPASSRLS / NOFORCERLS, `row_security` GUC, or debugging why an RLS policy is/isn't firing. Also covers security-barrier views (`WITH (security_barrier = true)`), which use the same qual-pushdown-prohibition machinery. Skip when the ask is about pg_hba.conf-level authentication, GRANT/REVOKE table-level privileges, SELinux (`sepgsql`), or database-level security features unrelated to per-row visibility.
matejformanek/postgres-claude/.claude/skills/testing Skill
2★ repoPick the right PostgreSQL test flavor for a core / contrib patch — covers pg_regress .sql / .out pairs, isolationtester specs and permutations for concurrency / deadlock races, TAP (PostgreSQL::Test::Cluster) for multi-node and pg_basebackup / replication / recovery scenarios, and src/test/modules for in-tree C test modules. Spans where test files live, how to wire them into the right schedule / meson.build, and how to run a single test fast (REGRESS_OPTS, --temp-instance, PROVE_FLAGS). Use whenever adding tests to a PG patch, reviewing a patch's test coverage, picking between regress / isolation / TAP for a new feature, debugging a regression diff, or asked "where should the test for X live". Skip for pytest / unittest / Jest / Vitest / Mocha / RSpec / JUnit / Go testing / Rust cargo-test app testing, pgbench / sysbench / HammerDB performance benchmarking, end-to-end / Selenium / Playwright web testing, and load / stress testing of production PG.
matejformanek/postgres-claude/.claude/skills/wal-and-xlog Skill
2★ repoAdd or modify a PostgreSQL WAL / XLOG record — covers choosing built-in rmgr vs Generic WAL (generic_xlog.c) vs custom rmgr (RegisterCustomRmgr), the XLogInsert + XLogRegisterBuffer idiom, writing a correct redo function, FPI / hint-bit (MarkBufferDirtyHint) rules, full-page-write handling, updating rmgrdesc + pg_waldump output, and bumping XLOG_PAGE_MAGIC when format changes. Use whenever a PG patch emits XLogInsert, adds an access method that needs durability, writes or modifies a redo function, registers a custom rmgr via RegisterCustomRmgr, or reviews a patch that changes WAL-record formats. Skip for MySQL binlog / GTID / row-based logging, SQLite WAL journal mode, Kafka log compaction / segment retention, pgbackrest / barman / wal-g operational config, recovery.conf / standby.signal DBA-side configuration, and generic write-ahead-logging theory or ARIES algorithm questions.
matejformanek/postgres-claude/.claude/skills/wire-protocol Skill
2★ repoPostgreSQL's frontend/backend wire protocol — the byte-level message format between client (libpq or any driver) and backend, plus the backend-side send/receive machinery. Covers `src/backend/libpq/pqcomm.c` (byte-stream framing) + `pqformat.c` (typed message building/parsing) + the message-dispatch loop in `tcop/postgres.c`. Loads when the user asks about protocol version 3.0/3.1, message types (Startup / Query / Bind / Execute / RowDescription / DataRow / CommandComplete / ReadyForQuery / ErrorResponse / etc.), simple vs extended query protocol, protocol negotiation, `pq_beginmessage` / `pq_sendstring` / `pq_endmessage` conventions, adding a new protocol message (has scenario `add-new-protocol-message`), or debugging "backend closed connection unexpectedly" wire-level. Skip when the ask is about libpq's client-side implementation (`src/interfaces/libpq/`), about the replication sub-protocol (walsender's variant), or about authentication protocol details (see `libpq-backend` subsystem).
ebarti/skills/ddia-batch-stream-processing Skill
2★ repoKnowledge from "Designing Data-Intensive Applications" (Kleppmann, 2nd ed) chapters 11-13 on batch processing, stream processing, and "A Philosophy of Streaming Systems" — covering MapReduce/dataflow engines, message brokers, change data capture, stream-processing time semantics, dataflow architectures, and end-to-end correctness. Use this skill when: - Choosing batch vs stream architecture - Designing an ETL/ELT pipeline - Implementing CDC (change data capture) - Picking a stream processor (Flink, Spark, Kafka Streams) - Designing real-time materialized views - Architecting a data lake/lakehouse - Ensuring exactly-once / end-to-end correctness - Building event-driven applications - Picking a message broker (Kafka, RabbitMQ, Pulsar, Kinesis) - Unbundling a monolithic database into composable systems - Deciding between event sourcing and CRUD - Reasoning about windowing, watermarks, and out-of-order events
ebarti/skills/ddia-data-modeling Skill
2★ repoData modeling, storage engines, and encoding choices distilled from "Designing Data-Intensive Applications" (Kleppmann, 2nd ed) chapters 3-5. Covers relational, document, graph, and event-sourced models; LSM, B-tree, in-memory, and columnar storage; specialized indexes; encoding formats; and modes of dataflow. Use this skill when: - Choosing a database (relational/document/graph) - Picking a storage engine (LSM/B-tree/columnar) - Designing an analytics warehouse - Selecting a wire format (JSON/Avro/Protobuf) - Deciding REST vs RPC vs messaging - Modeling event-sourced systems - Building search/vector/geo indexes
Growth-Today/claude-skills/gt-hubspot-admin/.claude/skills/hubspot-data-model Skill
2★ repoHubSpot data model, properties, objects, and imports. Use for property architecture and governance, property validation rules, field types, property groups, custom objects, association labels, calculated and rollup properties, the data model builder, record customization, and importing external data cleanly. Triggers on "hubspot properties", "property governance", "validation rules", "custom object", "association labels", "calculated property", "rollup property", "data model builder", "import data", "import mapping", "cleanup properties". Do NOT use for deduplication/enrichment (use hubspot-data-hygiene) or pipeline/deal setup (use hubspot-pipelines-deals).
Growth-Today/claude-skills/gt-salesforce-admin/.claude/skills/sf-data-model Skill
2★ repoSalesforce data model — validation rules, record types & page layouts, formula & roll-up summary fields, matching & duplicate rules, custom objects, and unused-field cleanup. Use for data quality at entry, schema design, and object modelling. Triggers on "validation rules", "record types", "page layouts", "formula field", "roll-up summary", "matching rules", "duplicate rules", "custom object", "cleanup fields", "schema". Do NOT use for dedup/merge cleanup (use sf-data-hygiene) or sales process/stages (use sf-opportunities-sales).
Celina-create/X-Studio/skills/stargazer-email-scraper Skill
2★ repoA solo studio for growth operators — skills, playbooks, templates.
shandar/pwp-plugin/skills/pwp-migrate Skill
2★ repoData and schema migration protocol — safe, reversible, verified migrations. Use this skill whenever the user needs to do a database migration, schema change, data transformation, platform move, or major dependency upgrade. Also use when they say 'add a column', 'change the schema', 'upgrade the database', 'move to a new host', 'backfill data', or 'major version upgrade'. Covers schema, data, platform, and dependency migrations with rollback strategies.
shandar/pwp-plugin/skills/pwp-security-audit Skill
2★ repoSecurity review protocol — systematic checks for common vulnerabilities and security hygiene. Use this skill whenever the user asks about security, wants a security audit, mentions vulnerabilities, OWASP, XSS, SQL injection, authentication issues, or secrets management. Also use when they say 'is this secure', 'check for vulnerabilities', 'security review', 'audit this for security', or 'are there any security issues'. Covers secrets, input validation, auth, authorization, data protection, dependencies, and error handling.
Timmy6942025/opencode-builder-skill/skills/opencode-mcp Skill
2★ repoUse this skill when adding Model Context Protocol (MCP) servers to OpenCode, configuring local or remote MCP servers, setting up OAuth authentication for MCP, managing MCP server permissions per agent, or troubleshooting MCP connection issues. Covers local/remote server types, OAuth flows, tool management, overriding remote defaults, and common MCP server examples.
ariana-dot-dev/cloud-sandbox-vm-skills/skills/public-url-hosting Skill
2★ repoHost a service on a stable public HTTPS URL straight from a cloud VM — start your app, run one command, get https://<box>-<port>.on.ascii.dev with managed TLS and token-gating. Supports bring-your-own domain and raw TCP/UDP via a dedicated IPv4. Use to host a web app, API, demo, or webhook endpoint without DNS or certificate setup.
pumarogie/claude-postgres-skills/skills/postgres-advanced-patterns Skill
2★ repoGuides production Postgres patterns when implementing multi-worker job queues and leases, batching writes, managing unbounded time-series partitions, or moving data between large live tables.
pumarogie/claude-postgres-skills/skills/writing-performant-queries Skill
2★ repoGuides evidence-first Postgres query diagnosis when an API or database becomes slow, an expensive query must be found, EXPLAIN must be used safely, the planner ignores an index, statistics may be stale, or a filter-and-sort query needs an index.
Maxwbh/oracle-skills-ptbr/skills/oracle-ords-ptbr Skill
2★ repoOracle ORDS — REST services e dicionário USER_ORDS_*/DBA_ORDS_*. ATIVE em define_module, define_template, define_handler, AutoREST, OAuth, ORDS_SECURITY, ORDS_SECURITY_ADMIN, JWT, PAR via ORDS_PAR, privilege, role ORDS, ORDS_EXPORT, USER_ORDS_MODULES, USER_ORDS_HANDLERS, USER_ORDS_SCHEMAS, DBA_ORDS_*, source_type_collection_query, CORS, versionamento de API, depreciação OAUTH package. Frases — "criar endpoint REST", "módulo ORDS", "autenticar API", "inventário de handlers ORDS", "OAUTH deprecated". NAO ATIVE em APEX pages, PL/SQL puro, DBA operacional. Templates em assets/.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-database-cassandra Skill
2★ repoKora Cassandra/ScyllaDB repositories over the DataStax driver via CassandraDatabaseModule. Covers @Repository extends CassandraRepository, @Query CQL, @EntityCassandra DAO records, @Column/@Id, @UDT user-defined types, @Batch writes, @CassandraProfile per-method consistency, custom CassandraRowMapper/CassandraResultSetMapper/CassandraParameterColumnMapper, and async signatures (CompletionStage, Mono/Flux, Kotlin suspend/Flow). Use when adding a Cassandra repository, mapping rows or UDTs, tuning consistency/timeout under cassandra.basic.request, or wiring contact points and keyspace.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-database-jdbc Skill
2★ repoJDBC relational database integration for Kora. Builds compile-time @Repository interfaces extending JdbcRepository with @Query, @EntityJdbc records, @Table/@Column/@Id mapping, SQL macros (%{return#selects}, %{entity#inserts}, %{entity#where = @id}), @Batch, UpdateCount, @Id-on-method generated identifiers, transactions via JdbcConnectionFactory.inTx(), and custom JdbcResultSetMapper/JdbcRowMapper/JdbcResultColumnMapper/JdbcParameterColumnMapper. Connection pooling is HikariCP, configured under the `db` HOCON/YAML section of JdbcDatabaseConfig. Use when adding a Hikari-backed PostgreSQL/MySQL/Oracle repository to a Kora service, wiring JdbcDatabaseModule, debugging "JdbcRepository not found" graph errors, or choosing repository return signatures.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-database-migration Skill
2★ repoKora database migration modules for Flyway and Liquibase that run schema migrations on application startup. Covers the FlywayJdbcDatabaseModule and LiquibaseJdbcDatabaseModule, the database-flyway and database-liquibase artifacts, FlywayConfig/LiquibaseConfig keys (locations, changelog, executeInTransaction, validateOnMigrate, mixed), versioned SQL scripts, and the recommended out-of-process strategy (Flyway Gradle plugin, K8s Job, CI) for horizontally scaled services. Use when wiring migrations into a @KoraApp, picking Flyway vs Liquibase, configuring flyway/liquibase config sections, or fixing checksum/race-condition failures on startup.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-grpc-client Skill
2★ repoBuilds gRPC clients in Kora via GrpcClientModule, the protobuf Gradle plugin, and generated stubs injected directly into components. Covers grpcClient.<ServiceName> HOCON/YAML config, plaintext vs TLS through the URL scheme, custom ClientInterceptor scoped with @Tag(ServiceGrpc.class) for metadata auth and logging, and unary plus server/client/bidirectional streaming with blocking and async stubs. Use when wiring an outbound gRPC call, injecting a *BlockingStub / *FutureStub / *Stub, adding authorization headers via gRPC metadata, configuring keepAliveTime/timeout/loadBalancingPolicy, or debugging UNAVAILABLE/UNAUTHENTICATED and missing-stub graph errors.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-grpc-server Skill
2★ repoBuilds gRPC server handlers in Kora using GrpcServerModule, @Component handlers that extend the generated *GrpcImplBase, io.grpc ServerInterceptor beans, grpcServer HOCON/YAML config (port, maxMessageSize, telemetry), the com.google.protobuf Gradle plugin, and gRPC Server Reflection. Use when serving gRPC RPCs (unary/server/client/bidirectional streaming) from a Kora service, mapping protobuf messages to a service layer, returning io.grpc.Status errors, or enabling reflection for grpcurl. Triggers on grpc-server, GrpcServerModule, *GrpcImplBase, StreamObserver, ServerInterceptor, reflectionEnabled.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-http-client-auth Skill
2★ repoAuthentication for outgoing Kora HTTP clients. Covers the built-in BasicAuthHttpClientInterceptor, ApiKeyHttpClientInterceptor and BearerAuthHttpClientInterceptor, the HttpClientTokenProvider interface, attaching them with @InterceptWith, and hand-written HttpClientInterceptor classes for custom schemes (OAuth2 client credentials, JWT with caching/refresh). Use when adding Basic/Bearer/API-key authorization to a @HttpClient, implementing token refresh for service-to-service calls, or debugging 401 responses from an external API. Not for server-side auth (use kora-http-server-auth).
kora-projects/kora-skills/plugins/kora-v1/skills/kora-http-server-auth Skill
2★ repoHTTP server authentication and authorization in Kora. Covers HttpServerPrincipalExtractor<T> wired to OpenAPI-generated ApiSecurity markers (BearerAuth/BasicAuth/ApiKeyAuth/OAuth) via @Tag, the Principal / PrincipalWithScopes marker interfaces, SecurityException-to-403 mapping through an HttpServerInterceptor, and the manual HttpServerInterceptor + HttpServerRequestMapper path for non-OpenAPI auth. Use when securing @HttpController/@HttpRoute endpoints, validating Bearer/JWT/API-key/Basic credentials, integrating an OpenAPI security scheme, or returning 401/403 from a Kora HTTP server.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-kafka-consumer Skill
2★ repoDeclarative Apache Kafka consumers in Kora via @KafkaListener over a @Component method, plus the KafkaModule. Covers consume strategies (subscribe with group.id vs assign), method signatures (value, key+value, Headers, ConsumerRecord, ConsumerRecords, manual Consumer commit), @Json deserialization with @Tag, deserialization-error handling with @Nullable Exception, KafkaSkipRecordException, ConsumerAwareRebalanceListener, batch processing, and telemetry. Use when consuming Kafka messages in a Kora service, wiring kafka.consumer config under @KafkaListener, choosing a commit/offset strategy, handling RecordValueDeserializationException, or testing a listener with @KoraAppTest and Testcontainers.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-kafka-producer Skill
2★ repoKafka message production in Kora via the @KafkaPublisher annotation on an interface. Covers @KafkaPublisher.Topic typed contracts, send signatures (void, RecordMetadata, Future/CompletionStage, ProducerRecord, Callback), @Json and @Tag serializer selection, KafkaPublishException handling, and transactional sends with TransactionalPublisher. Use when declaring a Kafka producer, publishing domain events, configuring kafka.producer.* driverProperties, or wiring a transactional Kafka publisher. Requires the ru.tinkoff.kora:kafka module, KafkaModule on @KoraApp, and the annotation-processors (Java) or symbol-processors (Kotlin).
kora-projects/kora-skills/plugins/kora-v1/skills/kora-telemetry-tracing Skill
2★ repoKora OpenTelemetry distributed tracing — OTLP exporter modules (OpentelemetryGrpcExporterModule / OpentelemetryHttpExporterModule), tracing.exporter config, Tracer injection, manual spans, and OpentelemetryContext propagation tied to the Kora request Context. Use when adding the ru.tinkoff.kora:opentelemetry-tracing-exporter-grpc or -http artifact, configuring an OTLP endpoint to Jaeger/Zipkin/Tempo, creating manual spans around business operations, propagating trace context across async/coroutine boundaries, or overriding the default Sampler in a @KoraApp.
kora-projects/kora-skills/plugins/kora-v1/skills/kora-testing-junit-java Skill
2★ repoIn-process JUnit 5 component and integration tests for Java Kora services. Covers @KoraAppTest, @TestComponent, @Mock/@Spy via Mockito, @Tag injection, KoraAppTestConfigModifier and KoraAppTestGraphModifier (KoraConfigModification, KoraGraphModification, TypeRef), the @KoraApp TestApplication submodule pattern, and Testcontainers (PostgreSQL + Flyway, Kafka). Use when writing JUnit 5 tests against a Kora dependency graph, mocking a component inside the graph, overriding test config/env, or spinning up a real database/broker. Artifact ru.tinkoff.kora:test-junit5.
Nordic-AI/production-readiness-skills/skills/security-audit Skill
2★ repoComprehensive application security audit covering OWASP Top 10, authentication, authorization, secret handling, input validation, cryptography, session management, CORS, CSP, security headers, and common injection vectors. Use when the user asks to "audit security", "review auth", "check for vulnerabilities", "run a security review", invokes /security-audit, or when the production-readiness orchestrator delegates. Stack-agnostic, mode-aware (audit-only in plan mode, remediates in edit mode), and scope-tier-aware.
drmhse/authos_skill/authos-rbac-control Skill
2★ repoManage AuthOS organization members, roles, invitations, SCIM tokens, and capability-based permissions. Use when implementing team administration, custom roles, service access grants, invitation flows, SCIM provisioning, or authorization checks inside an AuthOS tenant.
Authos service api integration
drmhse/authos_skill/authos-service-api-integration Skill
2★ repoIntegrate trusted backend services with AuthOS service API routes using X-Api-Key. Use when listing or managing service users, subscriptions, service metadata, service analytics, or provider-token requests from a server-side application.
drmhse/authos_skill/authos-web-integration Skill
2★ repoIntegrate AuthOS into browser, React, Vue, or plain TypeScript applications using @drmhse/sso-sdk and the AuthOS React/Vue adapters. Use when adding OAuth redirects, password login, magic links, passkeys, MFA callback handling, token refresh, or frontend session state.
drmhse/authos_skill/authos-webhook-integration Skill
2★ repoBuild AuthOS webhook receivers and manage tenant webhook subscriptions. Use when configuring organization webhooks, subscribing to event types, verifying live delivery signatures, testing delivery history, or using @drmhse/authos-node webhook helpers.
amirjahfar1/automate-seo-with-claude/skills/seo-api Skill
2★ repoDataForSEO API integration architect for developers. Covers the entire DataForSEO surface — DataForSEO Labs (ranked keywords, keyword ideas/suggestions/related, domain rank overview, competitors, domain/page intersection, subdomains, relevant pages, bulk keyword difficulty, bulk traffic estimation, search intent, historical rank/keyword/SERP data, top searches), SERP (Google + YouTube organic live advanced), Keywords Data (Google Ads search volume, Google Trends, DFS Trends), Backlinks (summary, backlinks, anchors, referring domains/networks, competitors, intersections, bulk metrics, time series), On-Page (instant pages, Lighthouse, content parsing), AI Optimization (LLM mention metrics, ChatGPT scraper, live LLM response, AI keyword data), and Merchant/Business data. For any "how do I…" question about endpoints, parameters, JSON bodies, per-call cost, rate limits, or authentication. Produces ready-to-paste cURL / Python / TypeScript / MCP-tool-call recipes against `https://api.dataforseo.com/v3/*` (HTTP Basic auth) and the `mcp__dataforseo__*` MCP tools. DataForSEO is stateless — no saved projects, rank-tracking state, or stored audits; stateful needs route to GSC (own verified site) / GA4 (own traffic) or scheduled DataForSEO pulls saved to local storage. Distinct from the other SEO skills which produce analysis deliverables (briefs, audits, reports); `seo-api` produces integration recipes. Use when the user asks "how do I use DataForSEO to do X", "what endpoint gives me Y", "cost of workflow Z", "build a rank tracker", "cURL / Python / TypeScript / MCP for DataForSEO", "what's the rate limit", "integrate DataForSEO with Looker / n8n / Sheets / BigQuery", or any direct question about DataForSEO endpoints, parameters, bodies, or wiring.
amirjahfar1/automate-seo-with-claude/skills/seo-firecrawl Skill
2★ repoAd-hoc web scraping, site mapping, and full-site crawling via Firecrawl MCP. Returns raw HTML, parsed metadata (og:*, twitter:*, JSON-LD, canonical, robots), JS-rendered DOM, and screenshots that WebFetch cannot. Distinct from the DataForSEO skills (which give keyword/traffic/SERP data) and from WebFetch (which gives markdown prose only). Use when the user says "scrape this page", "crawl this site", "map this site", "find all pages on", "get the OG tags", "get the JSON-LD", "render this JS-heavy page", or any task where raw `<head>` metadata, structured-data scripts, or post-JS DOM are the actual deliverable. Also invoked as a sub-step from other skills that need raw HTML.
buildmoonshot/skillpacks/skills/engineering/expert/security-pass Skill
2★ repoUse after writing or modifying code that handles untrusted input, authentication, authorization, secrets, file paths, database queries, shell commands, or outbound requests — before treating it as done. Makes the agent review its own change for common vulnerabilities instead of shipping them.
phucbm/skills/skills/backend/discord-as-backend Skill
no license2★ repoUse Discord as a lightweight backend for web apps — read a Forum channel as a structured database (bookmarks, link store) or push form submissions into a Discord channel via webhook. Trigger when the user wants zero-infra persistence using Discord, or wants a no-database form submission inbox.
natuleadan/skills/skills/010106-backend-architecture Skill
2★ repoBackend architecture — typed errors, structured API responses, domain modules, service/repository layering, env sanitization, and FK protection.
natuleadan/skills/skills/010117-drizzle-orm-patterns Skill
2★ repoDrizzle ORM schema patterns — domain factories, prd_/sys_/tst_ prefixes, FK constraints, vector+HNSW, JSONB+GIN, raw SQL, and the as any bridge.
natuleadan/skills/skills/060104-better-auth-rbac Skill
2★ repoRole-based access control with Better Auth — permission statements, createAccessControl, authorize() checks, dual auth, and frontend permission sync.
natuleadan/skills/skills/070101-prisma-database Skill
2★ repoPrisma 7 setup with PostgreSQL driver adapters and Better Auth schema models (User, Session, Account, Verification).
OpenSIN-AI/OpenSIN-Skills/engineering-team/senior-backend Skill
no license2★ repoDesigns and implements backend systems including REST APIs, microservices, database architectures, authentication flows, and security hardening. Use when the user asks to "design REST APIs", "optimize database queries", "implement authentication", "build microservices", "review backend code", "set up GraphQL", "handle database migrations", or "load test APIs". Covers Node.js/Express/Fastify development, PostgreSQL optimization, API security, and backend architecture patterns.
The same file is in 3 other repositories
OpenSIN-AI/OpenSIN-Skills/engineering-team/senior-data-engineer Skill
no license2★ repoData engineering skill for building scalable data pipelines, ETL/ELT systems, and data infrastructure. Expertise in Python, SQL, Spark, Airflow, dbt, Kafka, and modern data stack. Includes data modeling, pipeline orchestration, data quality, and DataOps. Use when designing data architectures, building data pipelines, optimizing data workflows, implementing data governance, or troubleshooting data issues.
The same file is in 1 other repository
OpenSIN-AI/OpenSIN-Skills/engineering/database-designer Skill
no license2★ repoUse when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data relationships.
The same file is in 1 other repository
OpenSIN-AI/OpenSIN-Skills/engineering/database-schema-designer Skill
no license2★ repoUse when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.
The same file is in 4 other repositories
OpenSIN-AI/OpenSIN-Skills/engineering/sql-database-assistant Skill
no license2★ repoUse when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.
The same file is in 4 other repositories
OpenSIN-AI/OpenSIN-Skills/product-team/code-to-prd Skill
no license2★ 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.
The same file is in 2 other repositories
OpenSIN-AI/OpenSIN-Skills/product-team/saas-scaffolder Skill
no license2★ 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.
The same file is in 4 other repositories
zachjxyz/jvn/template/.claude/skills/stack-knowledge Skill
2★ repoProject technology stack patterns for Next.js + Neon Postgres + Drizzle ORM + Better Auth + Tailwind CSS
edenfunf/promptc/examples/bloated-demo/.claude/skills/sql-safety Skill
2★ repoDatabase safety rules for the data-access layer.
v0idOS/performance-deity/archive/database-deity Skill
2★ repoA ruthlessly strict algorithmic optimization methodology for AI coding agents. Forces your agent to profile, benchmark, and mathematically prove performance gains before writing code.
v0idOS/performance-deity/skills/database Skill
2★ repoDiagnose and fix slow database queries. Runs EXPLAIN ANALYZE, identifies missing indexes, eliminates N+1 ORM patterns, and provides exact CREATE INDEX statements.
Makiya1202/ai-agents-skills/skills/mongodb Skill
no license2★ repoWork with MongoDB databases using best practices. Use when designing schemas, writing queries, building aggregation pipelines, or optimizing performance. Triggers on MongoDB, Mongoose, NoSQL, aggregation pipeline, document database, MongoDB Atlas.
the-hugin/RSIm/skills/backend-code-review Skill
no license2★ repoReview backend code for quality, security, maintainability, and best practices based on established checklist rules. Use when the user requests a review, analysis, or improvement of backend files (e.g., `.py`) under the `api/` directory. Do NOT use for frontend files (e.g., `.tsx`, `.ts`, `.js`). Supports pending-change review, code snippets review, and file-focused review.
the-hugin/RSIm/skills/postgres-patterns Skill
no license2★ repoPostgreSQL best practices for query optimization, schema design, indexing, RLS, and connection management. Includes Drizzle ORM patterns for TypeScript — schema definition, type inference, query builder style. Based on Supabase and lobehub guidelines.
the-hugin/RSIm/skills/web-scraper Skill
no license2★ repoScrape web pages, search the internet, and extract structured content using Python. Includes anti-bot/Cloudflare bypass via Scrapling. Use when the user wants to fetch a webpage, search for information online, extract links, crawl JS-rendered pages, or bypass bot protection.
wedabro/bro-skills/.agent/skills/speckit.backend Skill
2★ repoBackend/API Developer - Build API services, business logic, authentication, authorization, and standards-based integrations.
wedabro/bro-skills/.agent/skills/speckit.database Skill
2★ repoDatabase Architect - Design schemas, indexes, migrations, query optimization, and data integrity controls.
wedabro/bro-skills/.agents/skills/speckit.backend Skill
2★ repoBackend/API Developer - Build API services, business logic, authentication, authorization, and standards-based integrations.
wedabro/bro-skills/.agents/skills/speckit.database Skill
2★ repoDatabase Architect - Design schemas, indexes, migrations, query optimization, and data integrity controls.