Claude Skills by paulasilvatech

Explore a website with Playwright MCP, identify 3-5 core user flows, capture locators and expected outcomes, close the browser context, and propose test cases. Use this skill when the user asks to explore a site for testing, map UI functionality, discover test scenarios, or produce Playwright-ready interaction notes.

Generate, save, run, and stabilize Playwright TypeScript tests from a user scenario using Playwright MCP exploration evidence. Use this skill when the user asks to create a Playwright test, generate an @playwright/test spec from a scenario, automate a browser flow, or turn Playwright MCP history into a passing test.

Review existing PostgreSQL SQL, schema, migrations, functions, triggers, indexes, JSONB, arrays, custom types, domains, extensions, privileges, and Row Level Security for PostgreSQL-specific anti-patterns. Use when asked to audit or critique PostgreSQL code, database migrations, PL/pgSQL, RLS policies, or schema design.

Design, tune, and modernize PostgreSQL SQL, schemas, indexes, functions, and maintenance workflows using PostgreSQL-specific capabilities. Use this skill when the user asks for PostgreSQL optimization, query tuning, JSONB or array design, EXPLAIN ANALYZE interpretation, index strategy, full-text search, custom types, range/geometric types, pg_stat_statements, VACUUM, ANALYZE, partitioning, or secure parameterized database development.

Scaffold a Power Apps Code Apps preview project with Vite, React, TypeScript, PAC CLI, Power Apps SDK, PowerProvider, connector services, Fluent UI, package scripts, README, and deployment guidance. Use when asked to create, initialize, or configure a code-first Power Apps Code App project, add supported connectors, or prepare pac code push deployment.

Analyze and optimize Power BI DAX formulas for performance, readability, maintainability, variables, context transitions, filter efficiency, safe division, and best-practice function choice. Use when the user asks for a Power BI DAX formula optimizer, slow measure review, DAX refactor, or optimized measure with explanation.

Review Power BI data model architecture, relationships, storage modes, performance, security, governance, and maintainability. Use this skill when asked for a Power BI model design review, star schema assessment, relationship design evaluation, pre-production model review, modernization assessment, or optimization roadmap.

Diagnose and resolve Power BI performance issues across semantic models, reports, DAX, refresh, DirectQuery, gateways, and Fabric or Premium capacity. Use this skill when asked to troubleshoot slow Power BI reports, page loading, visual interactions, query execution, model refresh, capacity pressure, or gateway bottlenecks.

Design effective Power BI report layouts, chart selections, interactions, accessibility, mobile views, and implementation guidance. Use when asked for Power BI visualization design, dashboard layout, chart choice, KPI report structure, slicer/navigation design, accessibility review, mobile report design, or report UX consultation.

Transform business requirements, use case descriptions, and meeting transcripts into Power Platform solution architecture with component selection, process narrative, follow-up questions, and optional Mermaid.js diagrams. Use when asked to design a Power Apps, Power Automate, Dataverse, Power BI, Power Pages, Microsoft Copilot Studio, connector, gateway, or AI Builder architecture from discovery material.

Generate and validate Power Platform custom connectors that expose Model Context Protocol servers to Microsoft Microsoft Copilot Studio, including Swagger, apiProperties.json, script.csx, JSON-RPC 2.0 handling, schema compliance, OAuth hardening, certification preparation, and troubleshooting. Use when asked for MCP capabilities in Microsoft Copilot Studio, a custom connector for MCP tools/resources, or paconn/pac connector validation.

Guide Power BI semantic model design and optimization for well-documented models with star schema checks, DAX measures, relationships, RLS, naming, descriptions, calculation groups, performance tuning, and model validation. Use when working with Power BI semantic models, creating measures, adding relationships, configuring cardinality or cross-filter direction, documenting models, or optimizing DAX and model performance.

Open a browser-based GitHub pull request dashboard for a date range and role filter using the bundled CLI. Use when the user asks to show my PRs, open PR dashboard, check pull request status, see requested reviews, assigned PRs, all involved PRs, or review PR activity for a week, month, year, or explicit date range.

Embed before/after screenshots and annotated images in pull request descriptions so reviewers can inspect visible changes quickly. Use this skill when a PR changes layout, styling, CSS, charts, dashboards, data visualizations, UI components, forms, modals, error messages, CLI output, or log formatting.

Generate production-ready Product Requirements Documents for software systems and AI-powered features. Use when starting a product or feature cycle, translating a vague idea into requirements, defining AI system requirements, planning a feature, or creating a stakeholder source of truth.

Craft immersive, high-performance web interfaces with advanced motion, typography, scroll-driven interactions, responsive polish, and product-specific visual direction. Use this skill when the user asks for premium frontend UI, sophisticated animations, Awwwards-style components, high-end landing pages, layout polish, or high-end visual design implementation.

Generate technology-agnostic project workflow analysis blueprints that document end-to-end application flows, files, classes, entry points, service layers, data access, error handling, async processing, sequence diagrams, testing patterns, and implementation templates. Use this skill when the user asks to list all files/classes in a workflow, document representative workflows, map an API-to-database flow, or create an implementation-ready workflow blueprint.

Turn any rough prompt, half-formed idea, or task description into a finished, ready-to-send prompt optimized for any LLM model inside a chat interface — NOT the API. Use this skill whenever the user wants to write, rewrite, optimize, improve, sharpen, or polish a prompt for chat. Trigger phrases include "rewrite this prompt", "make this a better prompt", "optimize this prompt", "turn this into a prompt", "help me prompt this", "draft a prompt that...", "I want to ask...", or whenever the user...

Publish presentations and web content to GitHub Pages by converting PPTX, PDF, HTML, or Google Slides into a deployable site, creating or updating a repository, enabling Pages, and returning the live URL. Use when the user asks to publish slides, deploy HTML, share a presentation, convert a deck to GitHub Pages, or create a public Pages link.

Run pytest with coverage, read annotated coverage output, identify uncovered lines, and add tests until Python code reaches 100% line coverage. Use this skill when the user asks to run pytest coverage, inspect cov_annotate files, cover missing lines, target a module with --cov, or improve test coverage to 100%.

Build and operate Python Azure IoT Edge modules with reliable messaging, deployment manifests, observability, security, and production readiness checks. Use when creating Python IoT Edge modules, deploying edge manifests, processing telemetry at the edge, handling disconnected operation, or validating IoT Edge readiness.

Generate a complete Python Model Context Protocol server project using uv, mcp[cli], FastMCP, typed tools, optional resources and prompts, stdio or streamable-http transport, error handling, and testing instructions. Use when the user asks to generate a Python MCP server, create an MCP tool server, scaffold FastMCP, or build a streamable HTTP MCP service.

Build, test, type-check, version, package, and publish production Python libraries to PyPI. Use this skill when creating a pip-installable SDK, CLI, plugin, or utility; choosing `src/` vs flat layout; selecting setuptools, hatchling, flit, or poetry; configuring pyproject.toml, py.typed, Ruff, mypy, pre-commit, GitHub Actions, TestPyPI, Trusted Publishing, setuptools_scm, PEP 440, SemVer, or release governance.

Select and use official Qdrant client SDKs, REST API, gRPC API, and curated snippet search. Use this skill when the user asks for Qdrant API reference, client installation commands, SDK language choice, upload point examples, FastEmbed setup, or REST versus gRPC guidance.

Select the right Qdrant deployment model across local mode, Docker self-hosting, Qdrant Cloud, Hybrid Cloud, distributed deployment, and Qdrant EDGE. Use when someone asks how to deploy Qdrant, Docker vs Cloud, embedded Qdrant, local mode, self-hosted vs cloud, lowest latency, data residency, production readiness, or which deployment option fits a new vector search project.

Plan zero-downtime embedding model migrations in Qdrant with aliases, re-embedding, side-by-side collections, hybrid dense/sparse search, and bulk upload tuning. Use when switching embedding models, changing vector dimensions or providers, upgrading to hybrid search, re-embedding data, or A/B testing models.

Guide Qdrant monitoring, observability, health checks, Prometheus, Grafana, alerting, log centralization, and metric-based production debugging. Use when users ask how to monitor Qdrant, what metrics to track, whether Qdrant is healthy, why optimizers are stuck, why memory is growing, why requests are slow, or how to set up Prometheus or Grafana.

Diagnoses Qdrant production issues using metrics and observability tools. Use when someone reports 'optimizer stuck', 'indexing too slow', 'memory too high', 'OOM crash', 'queries are slow', 'latency spike', or 'search was fast now it's slow'. Also use when performance degrades without obvious config changes.

Guides Qdrant monitoring setup including Prometheus scraping, health probes, Hybrid Cloud metrics, alerting, and log centralization. Use when someone asks 'how to set up monitoring', 'Prometheus config', 'Grafana dashboard', 'health check endpoints', 'how to scrape Hybrid Cloud', 'what alerts to set', 'how to centralize logs', or 'audit logging'.

Diagnose and optimize Qdrant performance across search speed, indexing throughput, memory usage, query shape, HNSW and payload indexes, quantization, storage, and hardware trade-offs. Use when asked to improve Qdrant latency, throughput, indexing speed, RAM usage, or vector search efficiency.

Diagnoses and fixes slow Qdrant indexing and data ingestion. Use when someone reports 'uploads are slow', 'indexing takes forever', 'optimizer is stuck', 'HNSW build time too long', or 'data uploaded but search is bad'. Also use when optimizer status shows errors, segments won't merge, or indexing threshold questions arise.

Diagnoses and reduces Qdrant memory usage. Use when someone reports 'memory too high', 'RAM keeps growing', 'node crashed', 'out of memory', 'memory leak', or asks 'why is memory usage so high?', 'how to reduce RAM?'. Also use when memory doesn't match calculations, quantization didn't help, or nodes crash during recovery.

Diagnoses and fixes slow Qdrant search. Use when someone reports 'search is slow', 'high latency', 'queries take too long', 'low QPS', 'throughput too low', 'filtered search is slow', or 'search was fast but now it's slow'. Also use when search performance degrades after config changes or data growth.

Guide Qdrant scaling decisions for data volume, query throughput, query latency, query volume, tenant growth, sharding, and capacity planning. Use when someone asks how many nodes are needed, whether to scale vertically or horizontally, why a cluster is slow, how to shard, or how to add capacity.

Guides Qdrant query latency optimization. Use when someone asks 'search is slow', 'how to reduce latency', 'p99 is too high', 'tail latency', 'single query too slow', 'how to make search faster', or 'latency spikes'.

Diagnoses and guides Qdrant horizontal scaling decisions. Use when someone asks 'vertical or horizontal?', 'how many nodes?', 'how many shards?', 'how to add nodes', 'resharding', 'data doesn't fit', or 'need more capacity'. Also use when data growth outpaces current deployment.

Guides sliding time window scaling in Qdrant. Use when someone asks 'only recent data matters', 'how to expire old vectors', 'time-based data rotation', 'delete old data efficiently', 'social media feed search', 'news search', 'log search with retention', or 'how to keep only last N months of data'.

Guides Qdrant multi-tenant scaling. Use when someone asks 'how to scale tenants', 'one collection per tenant?', 'tenant isolation', 'dedicated shards', or reports tenant performance issues. Also use when multi-tenant workloads outgrow shared infrastructure.

Guides Qdrant vertical scaling decisions. Use when someone asks 'how to scale up a node', 'need more RAM', 'upgrade node size', 'vertical scaling', 'resize cluster', 'scale up vs scale out', or when memory/CPU is insufficient on current nodes. Also use when someone wants to avoid the complexity of horizontal scaling.

Guides Qdrant query throughput (QPS) scaling. Use when someone asks 'how to increase QPS', 'need more throughput', 'queries per second too low', 'batch search', 'read replicas', or 'how to handle more concurrent queries'.

Diagnose and improve Qdrant search relevance by separating embedding, payload, index, and query-strategy causes. Use when users report bad search results, wrong results, low precision, low recall, irrelevant matches, missing expected results, quantization regressions, model changes, data growth, or ask whether to use hybrid search, reranking, relevance feedback, or a different embedding model.

Diagnoses Qdrant search quality issues. Use when someone reports 'results are bad', 'wrong results', 'not relevant results', 'missing matches', 'recall is low', 'approximate search worse than exact', 'which embedding model', or 'quality dropped after quantization'. Also use when search quality degrades without obvious changes.

Guides Qdrant search strategy selection. Use when someone asks 'should I use hybrid search?', 'BM25 or sparse vectors?', 'how to rerank?', 'results are not relevant', 'I don't get needed results from my dataset but they're there', 'retrieval quality is not good enough', 'results too similar', 'need diversity', 'MMR', 'relevance feedback', 'recommendation API', 'discovery API', 'ColBERT reranking', or 'missing keyword matches'

Plan Qdrant server, SDK, storage, cluster, rolling, and Qdrant Cloud upgrades without interrupting availability or risking data integrity. Use this skill when the user asks how to upgrade Qdrant, move between minor versions, match SDK and server versions, perform a rolling upgrade, or use qcloud for Qdrant Cloud upgrades.

Run a complete quality engineering audit on any codebase. Derives behavioral requirements from the code, generates spec-traced functional tests, runs a three-pass code review with regression tests, executes a multi-model spec audit (Council of Three), and produces a consolidated bug report with TDD-verified patches. Finds the 35% of real defects that structural code review alone cannot catch. Works with any language. Trigger on 'quality playbook', 'spec audit', 'Council of Three', 'fitness-to...

Expert 10x engineer skill for interpreting and implementing code from shorthand, quasi-code, and natural language descriptions. Use when collaborators provide incomplete code snippets, pseudo-code, or descriptions with potential typos or incorrect terminology. Excels at translating non-technical or semi-technical descriptions into production-quality code.

Provide verified grep command libraries for React 18.3.1 and React 19 migration audits, including deprecated APIs, removed APIs, unsafe lifecycle methods, batching risks, tests, dependencies, and peer conflicts. Use this skill when writing or running React migration audit scan commands.

Create a React Container/Presentation component under src/components with TypeScript, Storybook, SCSS module, ui/features classification, optional Mantine replacement, and validation. Use when explicitly asked for a Container/Presentation component or when running /react-container-presentation-component.

Diagnose and fix React 18 automatic batching regressions in class components. Use when multiple setState calls occur after await, inside setTimeout, Promise .then() or .catch(), native addEventListener callbacks, or when tests fail because they assert intermediate state after a React 18 upgrade.

Check React 18.3.1 and React 19 dependency compatibility before npm installs, peer-dependency resolutions, or upgrade plans. Use when reviewing a React upgrade matrix, resolving npm peer conflicts, choosing minimum compatible package versions, deciding on --legacy-peer-deps, or separating a react-router v5 to v6 migration.