1.5K skills · sorted by relevance
Helps design ClickHouse tables, write analytical queries, and improve slow queries. Covers loading data in batches, preparing reusable summaries, and monitoring performance for large datasets, real-time dashboards, and time-series analysis.
Build Python APIs with FastAPI using clear routes, validated inputs, and consistent error handling. It guides asynchronous database and API calls, reusable dependencies, caching, and code organization to support readable implementations and responsive services.
Check opencode commands, HTTP server behavior, lifecycle events, and terminal startup with purpose-built scripts. Find stored sessions by ID, title, or scoped message searches, and export conversations as JSON for further inspection.
Implement Python services for Azure Cosmos DB NoSQL with guidance for authentication, data models, database operations, and tests. Separate business logic from storage access, validate data access permissions, and use reusable templates for consistent implementation.
Build Java applications that store, query, update, and delete data in Azure Cosmos DB. Covers synchronous and asynchronous clients, partition keys for distributing data, consistency settings, request usage, and error handling.
Plan a simple daily attendance register covering check-in, check-out, hours, absences, and correction requests. When requested, generate empty templates in CSV, SQL, JSON Schema, or Notion mappings to prepare records for payroll input.
Plan a central board for internal announcements, with fields for authors, audiences, publication dates, expiry dates, and acknowledgements. On request, generate empty templates in CSV, SQL, JSON Schema, or a Notion property mapping.
Create consistent records for evaluating AI agents, including task success, invalid tool calls, token use, and actual costs. Produce CSV tables, database definitions, and JSON validation schemas to support reproducible comparisons and checks for performance declines.
Structure an evidence-based comparison of shortlisted accounting packages using 57 fields for capabilities, costs, and evaluator judgments. Request empty templates in CSV, SQL DDL, JSON Schema, or Notion mapping while keeping the final decision with the business.
Organize primary and backup administrators, two-factor authentication, shared logins, and access review dates for each system. Get a practical register design or request empty templates in CSV, SQL, JSON Schema, or a Notion property mapping.
Guide Prisma 8 development by selecting task-specific references for data definitions, queries, migrations that change database structure, runtime setup, debugging, and upgrades. Check package versions and generated contract files before proceeding with implementation.
Set up Python APIs with FastAPI using organized project templates. Build routes, asynchronous database operations, authentication, and error handling, with examples for sharing dependencies and testing endpoints through a separate test database.
Create a Spring Boot Java project skeleton with Maven, database connection settings, and Docker Compose services. Adds dependencies for API documentation and architecture tests, then checks the generated project with a Maven test command.
Analyze Apache and Nginx access logs for attack attempts, scanner activity, and repeated login requests. Add geographic context to source IP addresses and produce a prioritized findings report to support intrusion investigations and monitoring reviews.
Review code for security vulnerabilities using a checklist covering unsafe input, authentication, access permissions, secrets, and data exposure. Classify findings into four severity levels to distinguish exploitable flaws, issues needing investigation, and smaller improvements.
Verify Kortix changes with focused tests and real inputs and outputs. This skill guides test placement, API and CLI workflows, browser checks, database verification, and reporting of results, including skipped cases.
Plan and operate Google Cloud Platform infrastructure using services such as Cloud Run and GKE, Google's managed Kubernetes service. Get guidance on deployment, access permissions, networking, monitoring, and cost controls for the system's requirements.
Audit database migration changes before a Bifrost release for lock contention, deadlocks, and delayed application startup. Receive pass, warning, or failure results, a release recommendation, and concrete remediation steps without modifying files.
Review Python changes against shared team standards to find bugs, missing regression tests, and security issues. Findings are ordered by severity and include file names and line numbers so reviewers can locate each problem.
Learn programming concepts through a short definition, a minimal code example, and a practical use case. Explanations adapt to experience level, highlight common mistakes, and suggest related topics and a small practice exercise.
Find test inputs and filter bypass examples for web security checks, organized by vulnerability type. Includes URL classification patterns, discovery wordlists, and examples of combining findings to demonstrate concrete security impact.
Scan projects for known dependency vulnerabilities, exposed credentials, and risky code patterns such as SQL injection. Produces text or JSON reports with file locations and severity levels, with options to run individual checks.
Query the H2 database created by tika-eval to get counts and comparisons missing from standard reports. Includes connection guidance and SQL examples for comparing extracted text, tracking encoding changes, and joining related file records.
Save working solutions, design decisions, code patterns, and failed approaches for future recall. The skill classifies entries, extracts tags, stores them in PostgreSQL with numerical text representations, and returns a record ID.