Claude Skills by paulasilvatech

Plan and implement end-to-end Microsoft Fabric data platforms and Medallion Architecture (Bronze/Silver/Gold) lakehouse patterns using PySpark, Delta Lake, Lakehouse/Warehouse items, Fabric Pipelines, and semantic-model handoff. Use for multi-layer workspaces, ingestion-to-analytics pipelines, Bronze-to-Silver-to-Gold notebook orchestration, layer-specific Fabric Spark tuning, and Materialized Lake View versus notebook decisions for Silver and Gold. For natural-language questions over existin...

Author and query Fabric Eventhouse / KQL databases: create tables, functions, policies, materialized views and ingestion, or run read-only KQL for real-time and time-series analytics. Ingestion topology is eventstream-cli. Triggers:kql query,query eventhouse,create kql table,kql ingestion,kql retention policy,materialized view kql

Author and inspect Microsoft Fabric Event Schema Sets (centralized catalogs of event types and message schemas) via the Fabric Items REST API with az rest: create, rename, override the definition or delete one; or list, inspect and base64-decode definitions read-only. Not the Eventstream ingestion pipeline (eventstream-*) nor Eventhouse/KQL (eventhouse-cli). Triggers:create event schema set,update event schema set definition,add event type to an event schema set,delete event schema set,list e...

Build and inspect Fabric Eventstream topologies: sources, operators, destinations and stream routing, plus read-only topology, retention, throughput and connection-string inspection. Querying landed events uses eventhouse-cli consumption mode. Triggers:create eventstream,add filter operator,CDC source,inspect eventstream topology,eventstream retention,list eventstreams

Author and explore Fabric IQ Ontology items: entity and relationship types, data bindings and definition updates, or schema, lineage, grounding and graph-walk exploration. Power BI report Q&A is fabriciq. Triggers:create ontology item,bind entity type,update ontology definition,entity types,ground query,ontology lineage

Answer natural-language business questions over existing Power BI reports and semantic models through the FabricIQ MCP endpoint. Orchestrates artifact discovery, schema inspection, entity resolution, DAX generation, and query execution to return plain-language answers. Use when the user asks what, which, compare, rank, explain, or summarize questions about the data in a Power BI report or semantic model, including asking for a DAX query to be run against a named model. Triggers: "ask power bi...

Automate the Microsoft Fabric Git integration lifecycle from CLI environments using the Fabric CLI (fab api), with az rest as a fallback. Use when the user wants to connect a workspace to Azure DevOps or GitHub, commit or update/pull workspace items, check Git sync status, resolve update conflicts, disconnect, automate Git sync with a service principal, or link a branch workspace to its base. Do NOT use for branch switching, for deployment tools (fab deploy, fabric-cicd, Bulk Import), for dep...

Port Azure HDInsight Spark clusters and Hive workloads to Microsoft Fabric. Replaces legacy HiveContext and standalone SparkContext constructors with the pre-instantiated SparkSession. Converts WASB and ABFS storage paths to OneLake abfss URLs via Shortcuts. Transforms Hive DDL (STORED AS ORC, external tables) to Delta Lake schemas inside Fabric Lakehouse. Maps Oozie workflow actions — spark, hive, shell, sqoop, coordinator — to Fabric Pipeline activities and schedule triggers. Introduces not...

Migrate Synapse Data Factory pipeline artifacts to Microsoft Fabric Data Factory. Handles: linked services → Fabric connections, dataset definitions inlined into pipeline activities, global parameters → Variable Libraries, SynapseNotebook activities → TridentNotebook. SSIS, SHIR-only, and Databricks activities are parked. Use when: (1) migrating Synapse pipelines to Fabric Data Factory, (2) converting SynapseNotebook activities to TridentNotebook, (3) translating linked services to Fabric con...

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 a complete MCP server and Power Platform custom connector optimized for Microsoft Copilot Studio, including streamable HTTP, JSON-RPC 2.0, schema constraints, apiDefinition.swagger.json, apiProperties.json, script.csx, tools, resources-as-tool-outputs, deployment, and validation. Use when asked for a Power Platform MCP connector generator or Copilot Studio MCP integration.

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.

Create and modify Power BI report files in PBIR/PBIP format using the `powerbi-report-author` and `powerbi-desktop` CLIs. Use when the user wants to: (1) implement an approved report spec or design brief, (2) add or edit pages, visuals, filters, slicers, bookmarks, themes, or formatting, (3) validate PBIR and verify rendering in Power BI Desktop. For open-ended visual design, use `powerbi-report-design` first. For end-to-end requirements and approval workflow, use `powerbi-report-planning` fi...

Generate Power BI report visual design guidance before PBIR files are written. Use when the user wants to: (1) choose tone, signature, page archetypes, chart types, layout, color, typography, theme direction, or accessibility approach, (2) redesign/restyle an existing report, apply a brand, or critique chart/layout choices, (3) produce a design contract for `powerbi-report-authoring`. For end-to-end requirements, approval, and build sequencing, use `powerbi-report-planning`. Triggers: "design...

Manage Power BI report workspace items and PBIR definitions in Microsoft Fabric via `az rest` CLI against the Fabric REST API. Use when the user wants to: (1) upload or publish a PBIR/report definition to Fabric, (2) get or download report definitions, (3) update report item definitions or properties, (4) list workspace reports, (5) delete reports. For editing PBIR files, pages, visuals, filters, themes, or formatting, use `powerbi-report-authoring`. For business questions over report data, u...

Build a guided requirements-to-implementation workflow for new Power BI reports and dashboards from semantic models, datasets, or PBIP projects. Use when the user wants to: (1) plan then implement a report, (2) define audience, scope, page plan, design direction, dependencies, and delivery target, (3) create a locked report spec with approval before PBIR authoring. For direct edits to existing report files, use `powerbi-report-authoring`. For design-only critique or redesign, use `powerbi-rep...

Author and inspect Power BI semantic models and their metadata: list tables, columns, measures, relationships; create, edit, deploy, refresh, and manage models; optimize DAX; build Import, DirectQuery, and Direct Lake models; configure data sources, permissions, connections; and prepare for AI/Copilot. Load this skill before acting on any semantic model authoring, metadata, or read-only inspection request: it picks the correct tool and method for the environment and permissions. Authoring-sco...

Search the Microsoft Fabric catalog across workspaces using the Fabric Catalog Search API. Use when the user wants to: (1) find an item by display name when the workspace is unknown, (2) list or discover items of a specific type across the tenant, (3) identify which workspace contains an item, (4) return item/workspace IDs for downstream API calls. Dataflow Gen1/Gen2 items are not supported. For data queries after the item is known, use the workload-specific consumption skill (`sqldw-cli`, `s...

Author and inspect Power BI semantic models and their metadata: list tables, columns, measures, relationships; create, edit, deploy, refresh, and manage models; optimize DAX; build Import, DirectQuery, and Direct Lake models; configure data sources, permissions, connections; and prepare for AI/Copilot. Load this skill before acting on any semantic model authoring, metadata, or read-only inspection request: it picks the correct tool and method for the environment and permissions. Authoring-sco...

Author, run and diagnose Fabric Spark: notebook cell code (%%configure, %%sql, PySpark, notebookutils), named notebook runs, Livy-session ad-hoc calculations, Spark failure triage, and the whole Materialized Lake View lifecycle -- definition, incremental-refresh readiness review, schedules, refresh jobs, run history and refresh-failure diagnosis. KQL materialized views are eventhouse-cli. Triggers:write notebook code,run notebook,notebookutils,create a Livy session,failed notebook,Spark OOM,c...

Design, read and troubleshoot a Fabric SQL database item (OLTP, SQL Server engine): schema with constraints, indexes and vector columns; sqlcmd lookups including temporal and similarity search; Query Store, blocking and regressed-plan investigation. Warehouse items belong to sqldw-cli. Triggers:create sqldb table,sqldb foreign key,dacpac deploy,sqldb sys.tables,vector similarity sqldb,sqldb query store,sql database blocked sessions

Author, query and diagnose Fabric Warehouse, Lakehouse SQL endpoints and Mirrored Databases: DDL/DML and COPY INTO ingestion, read-only T-SQL SELECT and row counts over lakehouse tables, and queryinsights performance triage. Fabric SQL database (OLTP) is sqldb-*-cli. Triggers:query warehouse,count rows lakehouse,SELECT lakehouse,create warehouse table,COPY INTO,warehouse MERGE,slowest warehouse queries,queryinsights CPU

Port Azure Synapse Analytics Spark workloads to Microsoft Fabric. Translates mssparkutils calls to notebookutils (including the env→runtime namespace change), replaces Linked Services with Fabric Data Connections and OneLake Shortcuts. Covers Spark Pools, Lake Databases, Notebooks, and Spark Job Definitions. Use when the user wants to: (1) port Synapse Spark notebooks to Fabric Lakehouse or Spark Job Definitions, (2) replace mssparkutils or Linked Services in Synapse code. Triggers: "migrate ...

Create, wire and operate Microsoft Fabric Variable Library items via Fabric REST API, az rest, curl, and jq. Use when the user wants to: (1) create or update a VariableLibrary definition, variables, settings.json, or valueSets/*.json overrides, (2) wire a Variable Library variable reference into a pipeline, notebook, Dataflow Gen2, copy job, shortcut, UDF, or Plan consumer, (3) read or set the active value set as item state per workspace or deployment stage, or (4) explain Variable Library CI...

Create, tune, validate, and publish RFC 8805 self-published IP geolocation CSV feeds for public IP space. Use when asked about "IP geolocation feeds", "RFC 8805", "geofeed CSV", "tune geofeed accuracy", "validate a geofeed", or "publish a self-published IP geolocation feed".

Build, scaffold, update, deploy, verify, and test Power Automate cloud flows through FlowStudio MCP. Use when asked to create a flow, build a flow definition, scaffold a workflow, deploy or PATCH an existing flow, wire connector connectionReferences, add actions, update triggers/actions, or generate Power Automate JSON without using the portal.

Debug failing Power Automate cloud flow runs through FlowStudio MCP with action-level inputs, outputs, and root-cause evidence. Use when asked why a flow failed, to inspect failed run details, diagnose ActionFailed, InvalidTemplate, DynamicOperationRequestFailure, connector auth, timeout, expression, or HTTP errors, or fix and verify a broken cloud flow.

Govern Power Automate flows and Power Apps at scale with the FlowStudio MCP cached store by classifying business impact, detecting orphaned resources, auditing connectors, enforcing compliance metadata, configuring notification rules, and computing archive or governance scores. Use when asked to tag flows, assign governance ownership, offboard makers, review compliance, audit security, or write governance metadata to FlowStudio.

Foundation skill for Power Automate through the FlowStudio MCP server: authentication, JSON-RPC helper code, tool discovery with list_skills and tool_search, oversized response parsing, and workflow-skill routing. Use this skill when connecting an agent to Power Automate, setting up FlowStudio MCP, checking auth, discovering flow tools, or preparing build, debug, monitoring, or governance workflows.

Monitor tenant-wide Power Automate health through the FlowStudio MCP cached store. Use when users ask for aggregate failure rates, run-health trends, maker/app inventory, inactive owners, compliance/health reports, monitored flows, or tenant governance summaries. Requires FlowStudio for Teams or MCP Pro+.

Prevent generic web and iOS interfaces by extracting product-specific design decisions from repository evidence and UIZZE's public catalogue of 800,000+ real web and iOS screens. Use this skill when building, refactoring, or reviewing UI, when asked to browse https://uizze.com before choosing a layout, or when the user wants a hard finish gate against interchangeable dashboard cards, filler metrics, vague headings, and generic calls to action.

Define and verify WCAG 2.2 AA, semantic, keyboard, focus, zoom, contrast, motion, media, data visualization, form, SPA, and native accessibility behavior. Use this skill when frontend design, implementation, review, testing, or release evidence involves accessibility.

Validate frontend behavior across REST, OpenAPI, GraphQL, WebSocket, SSE, AsyncAPI, authentication, uploads, mocks, contracts, ephemeral services, and backend failures. Use this skill when frontend work consumes remote data, services, schemas, generated clients, or realtime events.

Create or review focused frontend tests for components, hooks, composables, stores, validation, state machines, callbacks, and Storybook interactions using the repository's existing runner. Use this skill when isolated UI behavior and semantics need executable evidence.

Design and verify chat, copilot, assistant, streaming, citations, tool activity, attachments, multimodal input, conversation history, retry, stop, and accessible live-update behavior. Use this skill when frontend work includes conversational or generated-content interfaces.

Design and review dashboards, KPI surfaces, operational consoles, tables, chart selection, analytical interaction, and accessible data visualization from real questions and data properties. Use this skill when frontend work involves metrics, charts, monitoring, reporting, or data storytelling.

Generate or audit public-web metadata, canonical URLs, crawl policy, structured data, social previews, favicons, app icons, Web App Manifests, robots rules, and sitemaps without ranking guarantees. Use this skill when frontend work involves SEO, sharing previews, PWA identity, or public-route discoverability.

Establish product evidence, design contracts, complete UI states, anti-generic interface gates, and routing for frontend work. Use this skill when a material web, PWA, mobile, or desktop design, implementation, or quality request begins, before loading a narrower frontend domain skill.

Design and verify forms, validation, search, filters, settings, uploads, checkout, onboarding, destructive actions, and multi-step data-entry workflows with preserved input and recoverable async behavior. Use this skill when frontend work collects, validates, or submits user data.

Plan and verify mobile and desktop frontend behavior across React Native, Expo, Flutter, SwiftUI, Compose, Electron, Tauri, simulators, emulators, devices, lifecycle, gestures, windows, shortcuts, IPC, offline, and native accessibility. Use this skill when a non-browser surface requires runtime evidence.

Inspect, preview, install, update, and uninstall optional frontend instructions, VS Code prompts, and a named Playwright MCP workspace entry with ownership hashes and conflict protection. Use this skill when a consuming repository wants frontend-experience workspace companions.

Validate story-to-acceptance-to-scenario-to-evidence traceability, defect severity, required environments, and frontend release readiness, then issue Ready, Ready with follow-ups, or Blocked. Use this skill when final QA evidence or a release verdict is requested.

Convert frontend intent and repository evidence into INVEST-shaped user stories, Given/When/Then acceptance criteria, journey and state maps, and story-to-test traceability. Use this skill when feature discovery, acceptance criteria, Definition of Done, or an implementation handoff is needed.

Specify and verify hierarchy, layout, content, navigation, and interaction adaptations across viewports, containers, orientation, input methods, foldables, mobile browsers, tablets, desktop windows, and native surfaces. Use this skill when responsive or cross-device frontend work is requested.

Select risk-based frontend test layers, environments, fixtures, acceptance coverage, and release evidence without mandating every layer. Use this skill when planning QA scope, Definition of Done, regression coverage, test data, or frontend release criteria.

Explore and verify frontend journeys with Playwright, representative states and viewports, screenshots, visual regression, console and network evidence, stable fixtures, and reproducible defects. Use this skill when material browser UI behavior or rendered quality needs runtime proof.