skills.rest
9vantage
9vantageCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sqldb-consumption-cli

Query SQL database in Fabric via sqlcmd for read-only exploration, vector search, and security inspection.

Updated Jul 14, 2026
Search Tags:#vector search#sqlcmd#schema discovery#t-sql#microsoft fabric#sql database#read-only querying
One-click install
npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill sqldb-consumption-cli-9vantage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqldb-consumption-cli
Source: https://github.com/9vantage/skills-for-fabric-clone/tree/main/plugins/fabric-skills/skills/sqldb-consumption-cli
Command: npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill sqldb-consumption-cli-9vantage

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Analysts and engineers need a safe, read-only way to explore and query SQL databases in Microsoft Fabric without risking accidental data or schema modifications, while navigating the differences between the OLTP endpoint and the SQL analytics endpoint. ## Core Features & Use Cases - Agentic Schema Discovery: Run ordered sqlcmd queries to list schemas, tables, columns, constraints, indexes, and programmability objects before formulating queries. - Endpoint-Aware Querying: Choose between the OLTP endpoint (vector search, stored procedures, temporal queries, RLS enforcement) and the SQL analytics endpoint (cross-database queries, heavy aggregation, BI workloads). - Advanced Query Patterns: Execute vector similarity search for RAG scenarios, JSON parsing with OPENJSON/FOR JSON, temporal point-in-time queries, and security policy inspection (RLS, roles, permissions, audit logs). - Use Case: Ask the assistant to explore a Fabric SQL database, find tables containing customer embeddings, and run a vector similarity query to retrieve the most semantically similar records for a RAG application. ## Quick Start Ask the assistant to list all user tables with row counts in your Fabric SQL database using sqlcmd.

Frequently Asked Questions about sqldb-consumption-cli

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query a SQL database in Microsoft Fabric with sqlcmd?▼

Use the Go version of sqlcmd with the -G flag for Microsoft Entra authentication, specifying the server FQDN and database name discovered via the Fabric REST API. SQL authentication is not supported on Fabric, so always use Entra-based auth methods.

What is the difference between the SQL database endpoint and SQL analytics endpoint in Fabric?▼

The SQL database (OLTP) endpoint supports live transactional data, vector search, stored procedures, and security policy enforcement. The SQL analytics endpoint is read-only replicated data suited for cross-database queries and heavy aggregation, but it does not propagate RLS, vector, or json columns.

Can I run INSERT or UPDATE statements against a Fabric SQL database with this skill?▼

No, this is a strictly read-only consumption skill that refuses all DML and DDL statements including INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP. Write and schema-change requests are routed to the sqldb-authoring-cli skill instead.

Does SQL database in Fabric support vector similarity search for RAG?▼

Yes, vector similarity search is supported on the OLTP SQL database endpoint, making it suitable for RAG embedding scenarios. Verify that embedding columns are not NULL and that dimensions match, since vector columns are not mirrored to the analytics endpoint.

Why do cross-database queries fail in Fabric SQL database?▼

Three-part naming fails on the OLTP endpoint because it does not support cross-database queries. Switch to the SQL analytics endpoint, which allows querying across databases in the workspace using three-part names.

Why is my table or column missing from the SQL analytics endpoint?▼

Tables may be missing due to the 1000-table mirroring limit or unsupported primary key types, and columns are excluded if they are computed or use unsupported types like vector, json, xml, or geography. Query the OLTP endpoint to access these objects.

Related Skills

Explore More Data & Analytics Skills→
microsoftmicrosoft
1.1k

sqldb-cli

Manages Fabric SQL databases via sqlcmd for T-SQL authoring, querying, and performance diagnostics.

Official
Advanced
Umbral-BotUmbral-Bot

power-bi

Design Power BI reports with DAX measures, Power Query transformations, and REST API integrations.

Official
Advanced
microsoftmicrosoft
952

sqldw-operations-cli

Analyze Fabric Data Warehouse performance and diagnostics via CLI.

Official
Advanced
pgEdgepgEdge

pgedge-psql

Query and modify PostgreSQL databases via psql with compact CSV outputs.

Official
Advanced