sqldw-consumption-cli

Execute read-only T-SQL queries against Fabric Data Warehouse, Lakehouse SQL Endpoints, and Mirrored Databases via the MCP `fabric-sqlendpoint-execute_query` tool. Default skill for any lakehouse data query (row counts, SELECT, filtering, aggregation) unless the user explicitly requests PySpark or Spark DataFrames. Use when the user wants to: (1) query warehouse/lakehouse data, (2) count rows or explore lakehouse tables, (3) discover schemas/columns, (4) generate T-SQL scripts, (5) monitor SQL performance, (6) export results to CSV/JSON. For a Fabric notebook cell (%%sql or other notebook magics), use `spark-authoring-cli`, not this skill. Triggers: "warehouse", "SQL query", "T-SQL", "query warehouse", "show warehouse tables", "show lakehouse tables", "query lakehouse", "lakehouse table", "how many rows", "count rows", "SQL endpoint", "describe warehouse schema", "generate T-SQL script", "warehouse performance", "export SQL data", "connect to warehouse", "lakehouse data", "explore lakehouse".

インストールへ移動

リポジトリ: TuYv/ccpm
ソースの最終更新活動: 2026年8月14日 19:45
検出された SKILL.md の言語: 英語
スター: 1
フォーク: 2

インストール方法

デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。

Codex または Claude でインストールこの Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。

直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。

npx skills add https://github.com/TuYv/ccpm --skill sqldw-consumption-cli

コマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。

ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。

ソースファイルを確認

インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。

ファイルエクスプローラー

2 ファイル

SKILL.md

ソースの指示 · 読み取り専用プレビュー

検索に戻るインストールに戻る

name

sqldw-consumption-cli

description

Telemetry — MANDATORY. Every api.fabric.microsoft.com call must carry x-ms-fabric-skill: sqldw-consumption-cli (az rest: --headers "x-ms-fabric-skill=sqldw-consumption-cli"), including every LRO poll, fabric_lro and retry. Snippets omit it — add it anyway.

Update Check — ONCE PER SESSION (mandatory) The first time this skill is used in a session, run the check-updates skill before proceeding.

GitHub Copilot CLI / VS Code: invoke the check-updates skill.

Claude Code / Cowork / Cursor / Windsurf / Codex: compare local vs remote package.json version.

Skip if the check was already performed earlier in this session.

CRITICAL NOTES

To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering

Task	Reference	Notes
Finding Workspaces and Items in Fabric	COMMON-CLI.md § Finding Workspaces and Items in Fabric	Mandatory — READ link first [needed for finding workspace id by its name or item id by its name, item type, and workspace id]
Fabric Topology & Key Concepts	COMMON-CORE.md § Fabric Topology & Key Concepts
Environment URLs	COMMON-CORE.md § Environment URLs
Authentication & Token Acquisition	COMMON-CORE.md § Authentication & Token Acquisition	Wrong audience = 401; read before any auth issue
Core Control-Plane REST APIs	COMMON-CORE.md § Core Control-Plane REST APIs	Includes pagination, LRO polling, and rate-limiting patterns
OneLake Data Access	COMMON-CORE.md § OneLake Data Access	Requires `storage.azure.com` token, not Fabric token
Job Execution	COMMON-CORE.md § Job Execution
Capacity Management	COMMON-CORE.md § Capacity Management
Gotchas, Best Practices & Troubleshooting	COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting
Tool Selection Rationale	COMMON-CLI.md § Tool Selection Rationale
Authentication Recipes	COMMON-CLI.md § Authentication Recipes	`az login` flows and token acquisition
Fabric Control-Plane API via `az rest`	COMMON-CLI.md § Fabric Control-Plane API via az rest	Always pass `--resource`; includes pagination and LRO helpers
OneLake Data Access via `curl`	COMMON-CLI.md § OneLake Data Access via curl	Use `curl` not `az rest` (different token audience)
SQL / TDS Data-Plane Access	SKILL.md § Tool Stack	`fabric-sqlendpoint-execute_query` MCP tool — replaces sqlcmd
Job Execution (CLI)	COMMON-CLI.md § Job Execution
OneLake Shortcuts	COMMON-CLI.md § OneLake Shortcuts
Capacity Management (CLI)	COMMON-CLI.md § Capacity Management
Composite Recipes	COMMON-CLI.md § Composite Recipes
Gotchas & Troubleshooting (CLI-Specific)	COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific)	`az rest` audience, shell escaping, token expiry
Quick Reference	COMMON-CLI.md § Quick Reference	`az rest` template + token audience/tool matrix
Item-Type Capability Matrix	SQLDW-CONSUMPTION-CORE.md § Item-Type Capability Matrix	Read first — shows what's read-only (SQLEP) vs read-write (DW)
Connection Fundamentals	SQLDW-CONSUMPTION-CORE.md § Connection Fundamentals	TDS, port 1433, Entra-only, no MARS
Supported T-SQL Surface Area (Consumption Focus)	SQLDW-CONSUMPTION-CORE.md § Supported T-SQL Surface Area	Read before writing T-SQL — includes data types (no `nvarchar`/`datetime`/`money`)
Read-Side Objects You Can Create	SQLDW-CONSUMPTION-CORE.md § Read-Side Objects You Can Create	Views, TVFs, scalar UDFs, procedures
Temporary Tables	SQLDW-CONSUMPTION-CORE.md § Temporary Tables	Use `DISTRIBUTION = ROUND_ROBIN` for INSERT INTO SELECT support
Cross-Database Queries	SQLDW-CONSUMPTION-CORE.md § Cross-Database Queries	3-part naming, same workspace
Security for Consumption	SQLDW-CONSUMPTION-CORE.md § Security for Consumption	GRANT/DENY, RLS, CLS, DDM
Monitoring and Diagnostics	SQLDW-CONSUMPTION-CORE.md § Monitoring and Diagnostics	Includes query labels; DMVs (live) + `queryinsights.*` (30-day history)
Performance: Best Practices and Troubleshooting	SQLDW-CONSUMPTION-CORE.md § Performance: Best Practices and Troubleshooting	Statistics, caching, clustering, query tips
REST API: Refresh SQL Endpoint Metadata	SQLDW-CONSUMPTION-CORE.md § REST API: Refresh SQL Endpoint Metadata	Force metadata sync when SQLEP data is stale after ETL
System Catalog Queries (Metadata Exploration)	SQLDW-CONSUMPTION-CORE.md § System Catalog Queries	`sys.tables`, `sys.columns`, `sys.views`, `sys.stats`
Common Consumption Patterns (End-to-End Examples)	SQLDW-CONSUMPTION-CORE.md § Common Consumption Patterns	Reporting views, cross-DB analytics, temp table staging
Gotchas and Troubleshooting Reference	SQLDW-CONSUMPTION-CORE.md § Gotchas and Troubleshooting Reference	18 numbered issues with cause + resolution
Quick Reference: Consumption Capabilities by Scenario	SQLDW-CONSUMPTION-CORE.md § Quick Reference: Consumption Capabilities	Scenario → approach lookup
Schema and Object Discovery	discovery-queries.md § Schema and Object Discovery	Tables, columns, views, functions, procedures, cross-DB
Security Discovery	discovery-queries.md § Security Discovery
Statistics and Performance Metadata	discovery-queries.md § Statistics and Performance Metadata
Data Export Workflow	script-templates.md § Data Export Workflow	Query to CSV + parameterized date range export
Schema Discovery Workflow	script-templates.md § Schema Discovery Workflow	Full schema report via MCP
Performance Investigation Workflow	script-templates.md § Performance Investigation Workflow	Active queries, slow query analysis
Tool Stack	SKILL.md § Tool Stack	`fabric-sqlendpoint-execute_query` MCP tool + `az` CLI
Connection	SKILL.md § Connection
Agentic Exploration ("Chat With My Data")	SKILL.md § Agentic Exploration	Start here for data exploration
Script Generation	consumption-cli-quickref.md § Script Generation	When to emit a standalone bash/PowerShell script; `az rest` discovery + Legacy CLI Fallback
Monitoring and Performance	consumption-cli-quickref.md § Monitoring and Performance	Active queries DMV (read-only; session termination is out of scope)
Gotchas, Rules, Troubleshooting	SKILL.md § Gotchas, Rules, Troubleshooting	MUST DO / AVOID / PREFER checklists
Agent Integration Notes	consumption-cli-quickref.md § Agent Integration Notes	Per-agent CLI tips

Tool	Role	Install
`fabric-sqlendpoint-execute_query` MCP tool	Primary: Execute T-SQL queries against Fabric SQL Endpoints. Returns CSV results. Auth handled by MCP protocol.	No install — server-side. Requires MCP server registration (see below).
`az` CLI	Auth (`az login`), Fabric REST for workspace/item discovery.	Pre-installed in most dev environments
`jq`	Parse JSON from `az rest`	Pre-installed or trivial

Parameter	Type	Description
`workspaceId`	string (UUID)	The workspace GUID containing the target item
`itemId`	string (UUID)	The Fabric item GUID to query. For a Warehouse or Mirrored Database, use the item id. For a Lakehouse, use its SQL analytics endpoint id (`properties.sqlEndpointProperties.id`) — not the Lakehouse item id.
`query`	string	T-SQL query text (single batch — no `GO` separators or sqlcmd meta-commands)

Limit	Value	Notes
Max rows	10,000	Results are truncated beyond this. Use `TOP`, filters, or aggregations.
Query timeout	300 seconds	Long-running queries fail with timeout error.
Rate limit	20 requests/min per identity	HTTP 429 returned when exceeded. Retry after backoff.

Item Type	itemId Source	Read Queries	DML (INSERT/UPDATE/DELETE)
Warehouse	`GET /v1/workspaces/{wId}/warehouses` → item `id`	✅	✅
Lakehouse SQL Endpoint	`GET /v1/workspaces/{wId}/lakehouses` → `properties.sqlEndpointProperties.id` (not the lakehouse `id`)	✅	❌ (read-only)
Mirrored Database	`GET /v1/workspaces/{wId}/mirroredDatabases` → item `id`	✅	❌ (read-only)

sqldw-consumption-cli

インストール方法

ソースファイルを確認

SQL Endpoint Consumption — CLI Skill

Table of Contents

Tool Stack

MCP Tool Signature

MCP Limits

Supported Item Types

Connection

Discover workspaceId and itemId

Execute a Query

Agentic Exploration ("Chat With My Data")

Schema Discovery Sequence

Agentic Workflow

Gotchas, Rules, Troubleshooting

MUST DO

AVOID

PREFER

TROUBLESHOOTING

Symptom	Cause	Fix
MCP tool not available	MCP server not registered	Register `https://api.fabric.microsoft.com/v1/mcp/dataPlane/sqlEndpoint` in MCP client config
HTTP 401 / Unauthorized	Auth token expired or invalid	Re-authenticate (depends on MCP client — may need `az login` refresh)
HTTP 403 / Forbidden	Insufficient permissions on workspace/item	Verify user has Viewer+ role on the workspace/item
HTTP 404 / Not Found	Wrong workspaceId/itemId, or feature not enabled	Verify IDs via REST API; check if MCP feature is enabled for the tenant
HTTP 429 / Too Many Requests	Rate limit exceeded (20 req/min)	Wait and retry with backoff; consolidate queries
Query timeout (300s)	Query too complex or data too large	Simplify query, add filters, use `TOP`
Exactly 10,000 rows returned	Result truncation	Add `TOP N` or `WHERE` filters; use `COUNT(*)` to check total
"Invalid workspaceId/itemId"	Malformed UUID	Verify UUIDs are correct format (8-4-4-4-12 hex digits)
SQL error in response	T-SQL syntax error or invalid object	Fix T-SQL; verify table/column names via schema discovery
No rows but data exists	RLS filtering	Check `USER_NAME()`, verify RLS policies
`Invalid object name 'queryinsights...'`	New warehouse < 2 min old	Wait ~2 minutes

sqldw-consumption-cli

ソース情報

インストール方法

ソースファイルを確認

このリポジトリの他の Skills

このリポジトリの他の Skills

SQL Endpoint Consumption — CLI Skill

Table of Contents

Tool Stack

MCP Tool Signature

MCP Limits

Supported Item Types

Connection

Discover workspaceId and itemId

Execute a Query

Agentic Exploration ("Chat With My Data")

Schema Discovery Sequence

Agentic Workflow

Gotchas, Rules, Troubleshooting

MUST DO

AVOID

PREFER

TROUBLESHOOTING