agentsclimarketplace

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

  • Performing oauth scope minimization review

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/performing-oauth-scope-minimization-review Skill

    11★ repo

    'Performs OAuth 2.0 scope minimization review to identify over-permissioned third-party application integrations, excessive API scopes, unused token grants, and risky OAuth consent patterns across identity providers and SaaS platforms. Activates for requests involving OAuth scope audit, API permission review, third-party app risk assessment, or consent grant minimization.

  • Performing second order sql injection

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/performing-second-order-sql-injection Skill

    11★ repo

    Detect and exploit second-order SQL injection vulnerabilities where malicious input is stored in a database and later executed in an unsafe SQL query during a different application operation.

  • Performing sqlite database forensics

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/performing-sqlite-database-forensics Skill

    11★ repo

    Perform forensic analysis of SQLite databases to recover deleted records from freelists and WAL files, decode encoded timestamps, and extract evidence from browser history, messaging apps, and mobile device databases.

  • Performing web application penetration test

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/performing-web-application-penetration-test Skill

    11★ repo

    'Performs systematic security testing of web applications following the OWASP Web Security Testing Guide (WSTG) methodology to identify vulnerabilities in authentication, authorization, input validation, session management, and business logic. The tester uses Burp Suite as the primary interception proxy alongside manual testing techniques to find flaws that automated scanners miss. Activates for requests involving web app pentest, OWASP testing, application security assessment, or web vulnerability testing.

  • Testing api authentication weaknesses

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-api-authentication-weaknesses Skill

    11★ repo

    'Tests API authentication mechanisms for weaknesses including broken token validation, missing authentication on endpoints, weak password policies, credential stuffing susceptibility, token leakage in URLs or logs, and session management flaws. The tester evaluates JWT implementation, API key handling, OAuth flows, and session token entropy to identify authentication bypasses. Maps to OWASP API2:2023 Broken Authentication. Activates for requests involving API authentication testing, token validation assessment, credential security testing, or API auth bypass.

  • Testing api for broken object level authorization

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-api-for-broken-object-level-authorization Skill

    11★ repo

    'Tests REST and GraphQL APIs for Broken Object Level Authorization (BOLA/IDOR) vulnerabilities where an authenticated user can access or modify resources belonging to other users by manipulating object identifiers in API requests. The tester intercepts API calls, identifies object ID parameters (numeric IDs, UUIDs, slugs), and systematically replaces them with IDs belonging to other users to determine if the server enforces per-object authorization. This is OWASP API Security Top 10 2023 risk API1. Activates for requests involving BOLA testing, IDOR in APIs, object-level authorization testing, or API access control bypass.

  • Testing for json web token vulnerabilities

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-for-json-web-token-vulnerabilities Skill

    11★ repo

    Test JWT implementations for critical vulnerabilities including algorithm confusion, none algorithm bypass, kid parameter injection, and weak secret exploitation to achieve authentication bypass and privilege escalation.

  • Testing jwt token security

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-jwt-token-security Skill

    11★ repo

    Assessing JSON Web Token implementations for cryptographic weaknesses, algorithm confusion attacks, and authorization bypass vulnerabilities during security engagements.

  • Testing mobile api authentication

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-mobile-api-authentication Skill

    11★ repo

    'Tests authentication and authorization mechanisms in mobile application APIs to identify broken authentication, insecure token management, session fixation, privilege escalation, and IDOR vulnerabilities. Use when performing API security assessments against mobile app backends, testing JWT implementations, evaluating OAuth flows, or assessing session management. Activates for requests involving mobile API auth testing, token security assessment, OAuth mobile flow testing, or API authorization bypass.

  • Testing oauth2 implementation flaws

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-oauth2-implementation-flaws Skill

    11★ repo

    'Tests OAuth 2.0 and OpenID Connect implementations for security flaws including authorization code interception, redirect URI manipulation, CSRF in OAuth flows, token leakage, scope escalation, and PKCE bypass. The tester evaluates the authorization server, client application, and token handling for common misconfigurations that enable account takeover or unauthorized access. Activates for requests involving OAuth security testing, OIDC vulnerability assessment, OAuth2 redirect bypass, or authorization code flow testing.

  • Testing websocket api security

    Mikaru0Mystic/sectinel/arsenal/Anthropic-Cybersecurity-Skills/skills/testing-websocket-api-security Skill

    11★ repo

    'Tests WebSocket API implementations for security vulnerabilities including missing authentication on WebSocket upgrade, Cross-Site WebSocket Hijacking (CSWSH), injection attacks through WebSocket messages, insufficient input validation, denial-of-service via message flooding, and information leakage through WebSocket frames. The tester intercepts WebSocket handshakes and messages using Burp Suite, crafts malicious payloads, and tests for authorization bypass on WebSocket channels. Activates for requests involving WebSocket security testing, WS penetration testing, CSWSH attack, or real-time API security assessment.

  • Api audit

    Mikaru0Mystic/sectinel/arsenal/cybersecurity-skills/skills/api-audit Skill

    11★ repo

    Audit REST, GraphQL, and RPC APIs against the OWASP API Security Top 10 (2023). Use when the user mentions 'API security,' 'API audit,' 'BOLA,' 'broken object level authorization,' 'BFLA,' 'function-level authorization,' 'mass assignment,' 'API rate limiting,' 'GraphQL security,' 'REST security,' 'API authentication,' 'API authorization,' 'excessive data exposure,' or needs to review API endpoints for security weaknesses.

  • Iam audit

    Mikaru0Mystic/sectinel/arsenal/cybersecurity-skills/skills/iam-audit Skill

    11★ repo

    Audit, design, and migrate Identity and Access Management — cloud provider IAM (AWS, GCP, Azure), identity providers (Okta, Entra ID / Azure AD, Auth0, Google Workspace), application authorization (RBAC, ABAC, ReBAC), and federated identity. Use when the user mentions 'IAM,' 'identity,' 'access management,' 'least privilege,' 'role design,' 'SSO,' 'SAML,' 'OIDC,' 'OAuth,' 'JIT access,' 'just-in-time access,' 'break-glass,' 'service accounts,' 'RBAC,' 'ABAC,' 'privilege creep,' 'role explosion,' 'identity governance,' 'IAM strategy,' 'identity migration,' 'Okta,' 'Entra ID,' 'Azure AD,' 'Auth0,' 'Cognito,' or needs identity consultant-level guidance.

  • Web pentest

    Mikaru0Mystic/sectinel/arsenal/cybersecurity-skills/skills/web-pentest Skill

    11★ repo

    Perform black-box / grey-box web application penetration testing on an authorized target — auth bypass, IDOR, session handling, business-logic flaws, parameter tampering, Burp Suite / OWASP ZAP workflows. Use when the user mentions 'web pentest,' 'web application penetration test,' 'pentesting,' 'bug bounty,' 'Burp Suite,' 'ZAP,' 'OWASP testing,' 'authentication testing,' 'session testing,' 'authorization testing,' 'business logic testing,' 'web vulnerability testing,' or has explicit authorization to test a live web application.

  • Api design principles

    findscripter/everything-skills/02-engineering/api-design-principles Skill

    no license11★ repo

    当设计/评审 REST 或 GraphQL API、定接口规范、在范式间迁移时使用;做出资源命名、HTTP 语义、分页、版本化、错误格式、Schema 与 N+1 优化的可落地规范与方案;不适用于具体业务代码实现、框架运维部署、接口安全渗透测试;触发词:API 设计、REST、GraphQL、接口规范、endpoint、分页、版本化、HATEOAS、DataLoader、schema design

  • Api design reviewer

    findscripter/everything-skills/02-engineering/api-design-reviewer Skill

    no license11★ repo

    当评审新增/改动 API 端点的 PR、为 v2 迁移审计现有 API 或为团队制定 API 规范时使用;做 REST 约定 lint、破坏性变更检测与设计评分,产出问题清单与改进建议;不适用于 GraphQL/gRPC 接口设计、纯实现编码或后端性能压测;触发词:API 设计评审、api review、REST 规范、breaking change、破坏性变更、OpenAPI lint、接口评审、versioning

  • Api test suite builder

    findscripter/everything-skills/02-engineering/api-test-suite-builder Skill

    no license11★ repo

    当需要为 REST API 批量补齐集成/契约测试时使用;扫描 Next.js/Express/FastAPI/Django REST 路由并生成覆盖鉴权、入参校验、错误码、分页、文件上传、限流的可运行测试套件(Vitest+Supertest 或 Pytest+httpx);不适用于纯前端 UI、单元测试或 GraphQL/gRPC;触发词:生成 API 测试、集成测试套件、契约测试

  • Backend architecture patterns

    findscripter/everything-skills/02-engineering/backend-architecture-patterns Skill

    no license11★ repo

    当从零设计后端、拆分单体或制定团队架构规范时使用;用整洁架构/六边形/DDD 定义模块边界、接口与依赖规则,产出目录结构、端口适配器与迁移校验步骤;不适用于局部小重构、纯前端或简单 CRUD。触发词:整洁架构、六边形、DDD、端口适配器、依赖倒置、聚合根

  • Convex reactive backend

    findscripter/everything-skills/02-engineering/convex-reactive-backend Skill

    no license11★ repo

    当用 Convex 搭建/接入响应式后端,需设计 Schema、编写 TS 函数(query/mutation/action)、做实时订阅、鉴权、文件存储或定时任务时使用;产出可运行的 convex/ 函数、Schema、索引与客户端订阅代码;不适用于传统 SQL/ORM 或非 Convex 的 BaaS。触发词:Convex、响应式后端、实时订阅、useQuery

  • Database design advisor

    findscripter/everything-skills/02-engineering/database-design-advisor Skill

    no license11★ repo

    当需要做数据库选型(SQL/NoSQL)、设计 Schema、规划零停机迁移、优化索引与慢查询、设计分库分表与复制时使用;产出建模方案、迁移脚本(up/down)、索引与查询优化建议、选型决策矩阵;不适用于具体业务 SQL 调试代写、ORM 框架细节、运维集群部署。触发词:数据库设计、Schema、选型、迁移、索引、分库分表、慢查询

  • Database migration strategies

    findscripter/everything-skills/02-engineering/database-migration-strategies Skill

    no license11★ repo

    当需要在 Sequelize/TypeORM/Prisma 等 ORM 上做 schema 变更、跨库迁移或线上零停机发布时使用;产出可双向执行(up/down)的迁移脚本、回滚预案与零停机分阶段方案;不适用于纯查询调优、备份恢复运维或无 ORM 的手工 SQL 改库;触发词:数据库迁移、回滚、零停机

  • Dotnet backend patterns

    findscripter/everything-skills/02-engineering/dotnet-backend-patterns Skill

    no license11★ repo

    当用 C#/.NET 开发 Web API、MCP 服务或企业级后端、评审 C# 代码或设计服务架构时使用;产出符合现代最佳实践的异步、依赖注入、EF Core/Dapper 数据访问、Redis 缓存与 xUnit 测试代码及架构方案;不适用于前端、非 .NET 技术栈或纯运维部署。触发词:C#、.NET、async/await、依赖注入、EF Core、Dapper、IOptions、Redis 缓存、xUnit

  • Drizzle orm expert

    findscripter/everything-skills/02-engineering/drizzle-orm-expert Skill

    no license11★ repo

    当用 TypeScript 搭建类型安全数据库层时使用;做 Drizzle 表结构/关系定义、关系查询、Drizzle Kit 迁移与 Serverless 客户端接入并产出可运行代码;不适用于 Prisma/TypeORM 等非 Drizzle 栈或纯运维调优;触发词:drizzle、schema、pgTable、drizzle-kit、relations、Neon/Turso

  • Fastapi async api

    findscripter/everything-skills/02-engineering/fastapi-async-api Skill

    no license11★ repo

    当用 FastAPI 构建高并发异步 API/微服务、需要 async SQLAlchemy 2.0 + Pydantic V2 + JWT 鉴权、连接池与缓存等生产实践时使用;做异步端点、数据模型、依赖注入、测试与可观测性的设计与落地产物;不适用于同步 WSGI 框架(Flask/Django 同步视图)、纯前端或非 Python 服务。触发词:FastAPI、异步 API、Pydantic、SQLAlchemy async

  • Graphql architect

    findscripter/everything-skills/02-engineering/graphql-architect Skill

    no license11★ repo

    当设计或重构企业级 GraphQL 服务、需要联邦/网关聚合、解决 N+1 与缓存、加固鉴权或上线订阅时使用;做出可演进的 Schema、联邦子图与网关配置、DataLoader 批处理与字段级缓存、字段级鉴权与查询成本限流方案及落地代码;不适用于纯 REST/gRPC 接口、与 GraphQL 无关的通用后端或前端查询调试。触发词:GraphQL、Schema 设计、Apollo Federation、联邦/子图、N+1/DataLoader、订阅 subscription、查询复杂度限流

  • Grpc golang services

    findscripter/everything-skills/02-engineering/grpc-golang-services Skill

    no license11★ repo

    当用 Go 设计/实现生产级 gRPC 微服务(Protobuf 契约、流式、mTLS、可观测)时使用;产出基于 Buf 的契约定义、版本化 proto、mTLS 与拦截器接入方案及生成代码;不适用于纯 REST/HTTP 公网 API、gRPC-Web/浏览器集成、服务网格(Istio/Linkerd)流量路由与 L7 负载均衡配置。触发词:gRPC、Protobuf、Buf、mTLS、Go 微服务、proto 契约

  • Neon serverless postgres

    findscripter/everything-skills/02-engineering/neon-serverless-postgres Skill

    no license11★ repo

    当在 Serverless/Edge 环境接入 Neon Postgres,或需要数据库分支、连接池、Prisma/Drizzle 集成时使用;做 Neon 连接串配置、PgBouncer 连接池、分支化预览环境与冷启动应对的可执行方案;不适用于自建/非 Neon 的 Postgres 运维、SQL 调优本身、其他云数据库。触发词:Neon、serverless postgres、数据库分支、连接池、PgBouncer、预览环境

  • Prisma orm expert

    findscripter/everything-skills/02-engineering/prisma-orm-expert Skill

    no license11★ repo

    当用 Prisma ORM 做 schema 设计、迁移、查询优化、关系建模或排查连接/事务问题(覆盖 PostgreSQL/MySQL/SQLite)时使用;产出可落地的 schema/查询/迁移修复与最佳实践方案;不适用于裸 SQL 调优、数据库服务器/连接池等基础设施配置(转交对应专项);触发词:Prisma、schema.prisma、prisma migrate、N+1、$transaction、连接池

  • Rest api endpoint builder

    findscripter/everything-skills/02-engineering/rest-api-endpoint-builder Skill

    no license11★ repo

    当需要新建或扩展后端 REST API 端点时使用;按「路由→校验→鉴权→业务→错误处理→响应→文档→测试」分层产出生产级端点代码与规范;不适用于前端调用、GraphQL/gRPC 或纯架构选型;触发词:REST API、端点、路由、CRUD、接口

  • Saas multi tenant architecture

    findscripter/everything-skills/02-engineering/saas-multi-tenant-architecture Skill

    no license11★ repo

    当为多客户共享数据库的 SaaS 设计租户隔离时使用;产出 tenant_id 列设计、PostgreSQL RLS 策略、租户感知中间件与 ORM 自动作用域、跨租户 admin 与租户开通方案;不适用于单用户应用或纯鉴权无租户作用域。触发词:多租户、租户隔离、RLS、tenant_id、行级安全、数据泄漏

  • Shopify app development

    findscripter/everything-skills/02-engineering/shopify-app-development Skill

    no license11★ repo

    当用 Shopify CLI 开发应用/扩展/主题,调用 GraphQL Admin API,配置 OAuth、Webhook、计费、访问域、metafield 或 Shopify Functions 时使用;做脚手架搭建、GraphQL 查询/变更、Liquid 模板与扩展编码并落地可部署产物;不适用于通用电商建站、非 Shopify 平台或纯运营配置(无代码改动);触发词:Shopify、shopify app、GraphQL Admin、Liquid、checkout extension、metafield、webhook、Polaris。

  • Trpc typesafe api

    findscripter/everything-skills/02-engineering/trpc-typesafe-api Skill

    no license11★ repo

    当用 TypeScript 单仓前后端(Next.js/Remix/Express+React)需要免 Schema、免代码生成的端到端类型安全 API,或为已有 tRPC 加鉴权中间件、订阅、SSR 调用时使用;做 router/procedure 设计、Zod 输入校验、双 context 工厂、protectedProcedure、客户端 React Query 接线并产出可落地代码;不适用于跨语言/异构客户端、纯 REST/GraphQL 契约、裸 SQL 或 ORM 调优。触发词:tRPC、router、procedure、Zod、createTRPCContext、protectedProcedure、useQuery

  • Airflow dag builder

    findscripter/everything-skills/03-data/airflow-dag-builder Skill

    no license11★ repo

    当用 Apache Airflow 编排数据管道、调度批处理作业、设计 DAG 依赖、写自定义算子/传感器或本地测试与排障 DAG 时使用;做产出可上生产的幂等 DAG(TaskFlow、分支、传感器、重试告警、DagBag 测试);不适用于实时流处理、毫秒级低延迟调度或非数据工作流;触发词:airflow、DAG、数据管道、工作流编排、ETL 调度、批处理调度、TaskFlow、sensor、operator、cron 调度。

  • Airflow dag patterns

    findscripter/everything-skills/03-data/airflow-dag-patterns Skill

    no license11★ repo

    当用 Apache Airflow 编排数据管道、设计 DAG 依赖、实现算子/传感器或排查失败任务时使用;产出幂等、可观测、可测试的生产级 DAG 代码与运维约束;不适用于简单 cron/shell 或非 Airflow 技术栈。触发词:Airflow、DAG、数据管道、调度、TaskFlow、传感器、回填。

  • Apify multi platform scraper

    findscripter/everything-skills/03-data/apify-multi-platform-scraper Skill

    no license11★ repo

    当需要从社媒/地图/搜索等平台抓公开数据但还没选定具体 Apify Actor 时使用;做 AI 选 Actor→取 schema→运行→导出 CSV/JSON 的统一抓取流水线,覆盖 55+ Actor;不适用于登录/付费墙数据、无 APIFY_TOKEN、纯本地解析或写自定义爬虫。触发词:Apify、抓 Instagram/TikTok/YouTube/Facebook、Google Maps 商家、爬社媒、线索采集

  • Clickhouse analytics io

    findscripter/everything-skills/03-data/clickhouse-analytics-io Skill

    no license11★ repo

    当用 ClickHouse 做 OLAP 分析、设计 MergeTree 表、优化分析查询、建物化视图或批量灌数时使用;按「选引擎→定分区/排序键→写高效查询→批量插入→物化视图→监控」产出建表 DDL、优化后 SQL 与灌数代码;不适用于 OLTP/高频点写、事务强一致或非 ClickHouse 库(PostgreSQL/MySQL 等);触发词:ClickHouse、MergeTree、物化视图、列存分析、分区键、批量插入、慢查询日志。

  • Data pipeline engineer

    findscripter/everything-skills/03-data/data-pipeline-engineer Skill

    no license11★ repo

    当需要设计批处理/流式数据管道、数据仓库或湖仓架构、CDC 实时同步、数据质量与血缘治理时使用;做架构选型与可落地的摄取-转换-校验-监控管道实现及交付物;不适用于纯探索性数据分析、不含管道的 ML 建模、无法访问数据源或存储系统的场景。触发词:数据管道、Spark/dbt/Airflow、Kafka 流处理、湖仓 lakehouse、CDC、数据质量

  • Data scraper agent builder

    findscripter/everything-skills/03-data/data-scraper-agent-builder Skill

    no license11★ repo

    当需要为公开数据源(招聘/价格/新闻/GitHub/赛事等)搭一个定时抓取、用免费 LLM 打分结构化、写入 Notion/Sheets/Supabase 并从反馈学习的自动化 Agent 时使用;做"采集→丰富→存储"三层流水线脚手架与可跑代码,免费跑在 GitHub Actions;不适用于需登录/付费墙/违反 robots.txt 的私有数据、一次性手动抓取、纯入库后查询。触发词:定时抓取、监控网站、数据采集机器人、Gemini 结构化、GitHub Actions 爬虫、价格/职位监控

  • Dbt transformation modeler

    findscripter/everything-skills/03-data/dbt-transformation-modeler Skill

    no license11★ repo

    当用 dbt 搭建分析工程数据转换管道、按 staging/intermediate/marts 分层建模、加数据质量测试或做增量处理时使用;产出分层模型结构、SQL 模型、sources/schema YAML、测试与增量策略配置;不适用于实时流处理、非 dbt 的 ETL 编排或纯 SQL 即席查询;触发词:dbt、data build tool、分析工程、analytics engineering、数据建模、staging/marts 分层、medallion、增量模型、incremental、dbt 测试、source freshness、维度事实表 dim/fct。

  • Dbt transformation patterns

    findscripter/everything-skills/03-data/dbt-transformation-patterns Skill

    no license11★ repo

    当用 dbt 在数据仓库上搭建分层转换管道(staging/intermediate/marts)、加测试与文档、做增量模型时使用;产出分层命名规范、source/staging/mart 模型与 schema.yml 测试、增量物化策略及常用 dbt 命令清单;不适用于无 dbt/仓库的纯即席 SQL 查询或无源数据访问权限的场景。触发词:dbt、数据建模、增量模型

  • Erd schema designer

    findscripter/everything-skills/03-data/erd-schema-designer Skill

    no license11★ repo

    当从需求出发设计关系型数据库 schema、画 ERD、做范式化与表关系/约束/索引规划,或为多租户加隔离与软删除/审计字段时使用;产出实体关系模型(Mermaid ERD)、规范化表结构、关系与约束、索引与 RLS 策略草案;不适用于编写业务查询 SQL、本地 CSV 清洗、ORM/迁移工具具体语法调试;触发词:ERD、实体关系图、数据库设计、表结构设计、范式、normalization、schema design、多租户、软删除、索引策略、RLS

  • Nosql distributed db

    findscripter/everything-skills/03-data/nosql-distributed-db Skill

    no license11★ repo

    当为 Cassandra/ScyllaDB/DynamoDB 等分布式宽列/键值库做查询优先建模、选分区键、单表设计与排查热分区/高延迟时使用;产出访问模式清单、分区/排序键方案、单表与反范式 schema、热分区/打分区与索引(GSI/LSI/TTL)策略;不适用于关系型 SQL 建模、MongoDB 文档建模或单机 KV 缓存选型;触发词:cassandra、scylladb、dynamodb、分区键、热分区、单表设计、GSI、宽列、查询优先建模

  • Postgresql optimization

    findscripter/everything-skills/03-data/postgresql-optimization Skill

    no license11★ repo

    当 PostgreSQL 查询慢、需做索引设计、配置调优、VACUUM/膨胀治理或性能监控时使用;按「评估→EXPLAIN 分析→索引→改写→配置→维护→监控」七步产出优化方案与可执行 SQL;不适用于库选型、应用层逻辑或非 PG 数据库(MySQL/Oracle 等);触发词:PostgreSQL 慢查询、EXPLAIN ANALYZE、加索引、pg 调优、shared_buffers、autovacuum、表膨胀。

  • Snowflake development

    findscripter/everything-skills/03-data/snowflake-development Skill

    no license11★ repo

    当在 Snowflake 上写 SQL、搭数据管道、用 Cortex AI 或 Snowpark Python 时使用;产出符合最佳实践的 SQL/DDL、Dynamic Tables/Streams/Tasks 管道、Cortex 函数与 Agent、dbt 物化、性能与安全配置;不适用于其他数据库(MySQL/PostgreSQL/BigQuery)或纯通用 SQL 拼装;触发词:snowflake、雪花、dynamic table、动态表、streams、tasks、snowpipe、cortex、snowpark、dbt on snowflake、merge upsert、变体 variant

  • Sql query builder

    findscripter/everything-skills/03-data/sql-query-builder Skill

    no license11★ repo

    当需要把自然语言需求转成正确高效的 SQL、做联表/聚合/窗口查询或排错时使用;触发词:写 SQL、查询、联表、聚合、窗口函数、慢查询。

  • Vector database engineer

    findscripter/everything-skills/03-data/vector-database-engineer Skill

    no license11★ repo

    当为 RAG/语义检索/推荐做向量库选型与端到端落地,在 Pinecone/Weaviate/Qdrant/Milvus/pgvector 间权衡并设计分块、元数据与扩容时使用;产出选型对照、索引(HNSW/IVF/PQ)与元数据 schema 及上线清单;不适用于嵌入选型评估、纯索引调参或关系型/NoSQL 建模;触发词:向量数据库、Pinecone、Weaviate、Qdrant、Milvus、pgvector、语义检索、RAG、相似度搜索

  • Auth implementation patterns

    findscripter/everything-skills/08-security/auth-implementation-patterns Skill

    no license11★ repo

    当实现用户认证、保护 REST/GraphQL API、接入 OAuth2/SSO、设计会话或 RBAC、排查鉴权问题时使用;做认证策略选型、令牌生命周期、授权模型与策略执行点的安全实现并产出可落地代码与清单;不适用于仅做登录页 UI 文案/样式、纯基础设施无身份诉求、或无权改动鉴权策略与凭据存储的场景。触发词:JWT、OAuth2、RBAC、会话管理、令牌刷新、SSO。

  • Backend security coder

    findscripter/everything-skills/08-security/backend-security-coder Skill

    no license11★ repo

    当编写或评审后端代码与 API、需要防注入/认证授权/安全响应时使用;做输入校验、参数化查询、JWT/会话、CSRF/SSRF 防护、安全响应头与限流的落地实现与加固清单;不适用于纯前端、合规审计/威胁建模/渗透测试规划(交 security-auditor)。触发词:SQL注入、JWT、CSRF、限流、安全响应头

  • Broken authentication testing

    findscripter/everything-skills/08-security/broken-authentication-testing Skill

    no license11★ repo

    当对 Web 应用做认证/会话安全测试(已获书面授权)时使用;按 10 阶段方法对密码策略、用户名枚举、暴破/撞库、会话令牌与固定、超时、MFA、口令重置逐项检测并产出漏洞评估报告与修复建议;不适用于无授权测试、用真实泄露凭据登录他人账号、或第三方 SSO 越界;触发词:broken authentication、会话固定、JWT none、OTP 暴破、撞库

  • Alphafold database access

    findscripter/everything-skills/09-verticals/alphafold-database-access Skill

    no license11★ repo

    当需要按 UniProt ID 获取 AlphaFold 预测的蛋白 3D 结构、置信度或批量蛋白组数据时使用;用 BioPython/REST API/Google Cloud 下载 mmCIF/PDB 并分析 pLDDT 与 PAE,产出结构文件、置信度报告与高可信区域。不适用于实验结构(用 PDB)或自行跑预测(用 ColabFold/本地 AlphaFold)。触发词:AlphaFold、UniProt、pLDDT、PAE、蛋白结构预测、蛋白组下载

  • Archs4 expression database

    findscripter/everything-skills/09-verticals/archs4-expression-database Skill

    no license11★ repo

    当需要查 ARCHS4 跨 100 万+ 人/鼠 RNA-seq 样本的组织表达 z-score、共表达基因、按元数据搜样本,或取批量 HDF5 表达矩阵时使用;用 requests 直连 REST API(免鉴权)产出组织 z-score 表、共表达基因表、GEO/SRA 样本表与组织柱状/热图。不适用于变异群体频率(用 gnomad-population-database)、基因列表通路富集(用 gget-genomic-databases/gene-set-enrichment-analysis)、原始 series matrix 下载(用 geo-database)。触发词:ARCHS4、z-score、共表达、组织表达、RNA-seq、HDF5

  • Brenda enzyme database

    findscripter/everything-skills/09-verticals/brenda-enzyme-database Skill

    no license11★ repo

    当需要按 EC 号/底物/物种查询酶动力学参数(Km、kcat、Vmax、Ki)、底物-产物、抑制剂、辅因子、最适 pH/温度或交叉 UniProt 时使用;用 Python zeep 调 BRENDA SOAP 服务(SHA256 鉴权、需免费学术注册)检索并产出可用于动力学建模的参数表。不适用于代谢网络约束建模(用 cobrapy)或代谢物结构(用 hmdb)。触发词:BRENDA、酶动力学、Km、kcat、Vmax、Ki、EC 号、米氏常数、底物特异性、抑制剂、辅因子、最适pH温度

  • Chembl bioactivity database

    findscripter/everything-skills/09-verticals/chembl-bioactivity-database Skill

    no license11★ repo

    当需要查询化合物、靶点或 IC50/Ki/EC50 等生物活性数据、做相似性/子结构检索或 SAR 分析时使用;用纯 requests 调 ChEMBL 公共 REST/JSON API(免 SDK、免鉴权)检索化合物/靶点/活性/药物机制与适应症并产出结构化结果。不适用于 SMILES 操作/指纹/描述符(用 rdkit)或更广覆盖的 PubChem 化合物检索。触发词:ChEMBL、生物活性、IC50/Ki/EC50、靶点抑制剂、SAR、相似性检索、药物机制

  • Clinicaltrials database search

    findscripter/everything-skills/09-verticals/clinicaltrials-database-search Skill

    no license11★ repo

    当需要按疾病、药物/干预、地点、申办方或试验阶段检索全球临床试验,或按 NCT 编号取详情、按状态过滤、翻页、导出 CSV 时使用;用纯 requests 调 ClinicalTrials.gov API v2(公开免鉴权)检索研究并产出结构化结果/CSV。不适用于化合物生物活性(用 chembl-bioactivity-database)或综合科研多库查询(用 scientific-database-lookup)。触发词:临床试验、ClinicalTrials.gov、NCT、招募状态、试验阶段、患者匹配、试验申办方

  • Clinpgx pharmacogenomics database

    findscripter/everything-skills/09-verticals/clinpgx-pharmacogenomics-database Skill

    no license11★ repo

    当查询药物基因组临床注释、CPIC/DPWG 用药指南、基因-药物对、FDA/EMA 药物标签或基因型→用药建议时使用;做 ClinPGx REST API(api.clinpgx.org,注释)+ CPIC PostgREST API(api.cpicpgx.org,处方建议)双主机查询,产出证据分级注释表与基因型特异性用药建议;不适用于胚系致病性(用 clinvar)、体细胞肿瘤 PGx(用 cosmic/opentargets)、药物活性数据(用 chembl)。触发词:ClinPGx、PharmGKB、CPIC、药物基因组、CYP2C19、用药指南

  • Clinvar database

    findscripter/everything-skills/09-verticals/clinvar-database Skill

    no license11★ repo

    当需要查询某变异的临床意义/致病性/疾病关联或筛出基因致病变异时使用;通过 NCBI E-utilities(ESearch/ESummary/EFetch)按基因/rsID/疾病/审阅星级检索 ClinVar,产出 ClinSig、审阅状态、疾病与提交者数据;不适用于 GWAS 群体关联(用 gwas-database)、变异功能后果预测(用 Ensembl VEP)、体细胞肿瘤变异(用 cosmic-database)。触发词:ClinVar、致病性、临床意义、rsID 查询、致病变异

  • Dbsnp database

    findscripter/everything-skills/09-verticals/dbsnp-database Skill

    no license11★ repo

    当按 rsID/基因/区间查 dbSNP 的等位基因/MAF/变异类型/坐标或批量解析 rsID 时使用;经 NCBI E-utilities 与 Variation Services API 产出 snp_class、global_mafs、chrpos 及 ClinVar/gnomAD 交叉引用;不适用于临床致病性策展(用 clinvar-database)或按祖源分层频率(用 gnomad-population-database)。触发词:dbSNP、rsID、SNP 频率、MAF、变异坐标、批量注释 rsID

  • Drugbank database access

    findscripter/everything-skills/09-verticals/drugbank-database-access Skill

    no license11★ repo

    当需要从本地 DrugBank XML 离线查询药物信息、药物相互作用(DDI)、靶点/酶/转运体或化学性质时使用;做按 ID/名称/CAS 检索、提取带严重度的 DDI、映射靶点与外部库 ID、算 SMILES 相似度,产出结构化药物数据/表格。不适用于实时生物活性(IC50/Ki 用 chembl)或免下载库的化合物属性查询(用 pubchem)。触发词:DrugBank、药物相互作用、药物靶点

  • Emdb cryoem database

    findscripter/everything-skills/09-verticals/emdb-cryoem-database Skill

    no license11★ repo

    当需要按关键词检索 EMDB 冷冻电镜/电子断层密度图、取分辨率/方法/物种等元数据、找拟合 PDB 原子模型、推导 .map.gz 下载链接或抽取引用时使用;用 requests 直连 Entry REST API + EBI Search WS,产出元数据、map 下载 URL、拟合 PDB ID 与 DOI/PMID。不适用于实验原子坐标(用 pdb-database 思路或 RCSB)或 AI 预测结构(用 alphafold-database-access)。触发词:EMDB、cryo-EM、密度图、EMD-XXXXX、EBI Search

  • Encode database

    findscripter/everything-skills/09-verticals/encode-database Skill

    no license11★ repo

    当需要从 ENCODE Portal/SCREEN 取调控基因组数据——按 assay(TF ChIP-seq/ATAC-seq/DNase-seq/组蛋白 ChIP/RNA-seq)+靶点+细胞系检索实验、下载 BED/bigWig 峰文件、按区域或基因查 cCRE 候选顺式调控元件——以注释变异、定位开放染色质或建参考峰集时使用;做 REST/SCREEN 取数并产出实验表/峰文件/cCRE 分类表(PLS/pELS/dELS/CTCF-only);不适用于变异调控打分(用 RegulomeDB)、GWAS 关联(用 GWAS Catalog)或自有 BAM 出 bigWig/call peak(用 deeptools/macs3);触发词:ENCODE、cCRE、SCREEN、ChIP-seq 峰、ATAC-seq、DNase-seq、开放染色质、调控元件、bigWig、IDR peaks