Skip to main content
Glama
612,516 tools. Updated 2026-09-26 16:07

"An Overview of Microsoft SQL Server" matching MCP tools:

  • Run a read-only SQL query against an app's Postgres database and return up to 200 result rows. SELECT only — writes and DDL (INSERT/UPDATE/DELETE/ALTER/DROP/…) are rejected server-side; use vibekit_chat or vibekit_submit_task to have the agent make data or schema changes. Call vibekit_db_schema first to learn the tables. SQL string, max 5000 chars.
    ConnectorNo auth
  • Deletes one or more records through a Caspio view that match the WHERE clause. This is irreversible. In multi-table views, only records from the primary table are deleted. WHERE is required and supports Microsoft SQL Server syntax. A broad WHERE clause will delete all matching records. To delete a single record, filter by PK_ID or another unique field. Returns the count of deleted records. IMPORTANT: field names in WHERE are case-insensitive and must come from discover_views' field list -- never guess. Call discover_views first for any view not already discovered earlier in this conversation to get its viewId.
    Connector
    Destructive
    OAuth
  • Fetch and convert a Microsoft Learn documentation webpage to markdown format. This tool retrieves the latest complete content of Microsoft documentation webpages including Azure, .NET, Microsoft 365, and other Microsoft technologies. ## When to Use This Tool - When search results provide incomplete information or truncated content - When you need complete step-by-step procedures or tutorials - When you need troubleshooting sections, prerequisites, or detailed explanations - When search results reference a specific page that seems highly relevant - For comprehensive guides that require full context ## Usage Pattern Use this tool AFTER microsoft_docs_search when you identify specific high-value pages that need complete content. The search tool gives you an overview; this tool gives you the complete picture. ## URL Requirements - The URL must be a valid HTML documentation webpage from the microsoft.com domain - Binary files (PDF, DOCX, images, etc.) are not supported ## Output Format markdown with headings, code blocks, tables, and links preserved.
    ConnectorNo auth
  • Fetch a disaster record by ReliefWeb numeric ID including description, affected countries, GLIDE number, profile overview, key content links, and active appeals or response plans. Use after reliefweb_search_disasters to retrieve full details. Each curated list also has an archive, which the record leaves out. Two alternative selectors, at most one per call: sections names parts of the record to return, archive pages one list's archived entries in place of the record. Description and profile overview can together run to tens of KB for major disasters. A record over the response budget comes back as a section outline naming every section and its byte size. Nothing is truncated on any path.
    ConnectorNo auth
  • List the SQL databases (D1 or Neon Postgres) on my account, including which owned site (if any) each is attached to. Call this BEFORE db_query/db_schema-style work to discover a databaseId — those live on a per-database MCP server reached via GET /api/v1/databases/{id} (see llms.txt), which this id feeds.
    ConnectorNo auth
  • Updates one or more records in a Caspio table that match the WHERE clause. The payload is a flat JSON object containing only the fields to update (e.g., {'Status': 'Closed', 'ClosedDate': '2026-01-15'}). Fields not included in the payload remain unchanged. WHERE is required and supports Microsoft SQL Server syntax. Be cautious: a broad WHERE clause will update all matching records. To update a single record, filter by PK_ID or another unique field. Returns all updated records. IMPORTANT: field names are case-insensitive and must come from discover_tables' field list -- never guess. Call discover_tables first for any table not already discovered earlier in this conversation to get its tableId.
    ConnectorOAuth

Matching MCP Servers

  • A
    license
    Not graded
    quality
    D
    maintenance
    Enables AI assistants to connect and query Microsoft SQL Server databases using natural language, executing read-only SQL queries for safe data inspection and analysis.
    MIT
  • A
    license
    A
    quality
    C
    maintenance
    Enables developers and product owners to scan a codebase and extract a readable business overview—features, roles, access control, data model, and endpoints—along with findings on missing or inconsistent rules, and generate shareable HTML or Markdown reports and diagrams.
    9
    2
    MIT

Matching MCP Connectors

  • Updates one or more records through a Caspio view that match the WHERE clause. The payload is a flat JSON object containing only the fields to update (e.g., {'SaleStatus': 'Closed', 'SaleAmount': 1000}). Fields not included in the payload remain unchanged. In multi-table views, only fields from the primary table can be updated (check Editable=true in the view's field definitions). WHERE is required and supports Microsoft SQL Server syntax. A broad WHERE clause will update all matching records. To update a single record, filter by PK_ID or another unique field. Returns all updated records. IMPORTANT: field names are case-insensitive and must come from discover_views' field list -- never guess. Call discover_views first for any view not already discovered earlier in this conversation to get its viewId.
    ConnectorOAuth
  • Start an OAuth Connect and get the consent URL to open in a browser. Pass provider (github|google|x|atlassian|microsoft|slack|notion|gitlab|discord|reddit|linear — account-wide, reused everywhere) OR server_url (any MCP server; Rokha runs the MCP auth-spec handshake, grant bound to that server). On approval the token lands in the vault under the returned alias. Requires a logged-in identity.
    ConnectorNo auth
  • List all available SDM domains (top-level industry categories) with the count of data models in each. Use this as the entry point when the user wants an overview of what sectors are covered, or before calling list_models_by_domain. No parameters required. Example: list_domains({})
    ConnectorNo auth
  • Start here when building an application. Returns an overview of what the AdCritter platform offers and a catalog of feature guides you can query with the adcritter_guidance tool to learn how to build each part of the app. Call adcritter_guidance(key) for any feature area to get detailed building instructions with API endpoints and response shapes.
    ConnectorNo auth
  • Run a read-only SQL SELECT against water data tables staged on a DataCanvas by water_get_series or water_find_sites. Workflow: run water_get_series or water_find_sites (get canvas_id + table_name) → water_dataframe_describe (confirm the table and its columns) → water_dataframe_query (SQL analysis). Only SELECT statements are permitted. At most 10,000 rows are returned; a query matching more is capped and the response sets truncated=true — scope with WHERE/LIMIT, and use SELECT COUNT(*) or water_dataframe_describe to learn the true match count. Requires DataCanvas to be enabled on this server instance. Returns an error if DataCanvas is not available.
    ConnectorNo auth
  • Returns the current skill cluster data for public jobs on the nü people website. Use this tool when the user wants an overview of which skills or technologies are currently in demand.
    ConnectorNo auth
  • COMPLETE list of the temporary previews on this Nippy account, with expiry times — permanent sites are not included. For a combined overview of sites and previews, use list_sites.
    ConnectorOAuth
  • Canonical profile of a US internet provider by name (handles brand variants, e.g. 'ATT', 'Google Fiber'). Returns the canonical identity, FCC registration numbers, technologies filed, the live profile URL, and — when precomputed — an answer pack of grounded sections (overview, coverage, measured-vs-claimed speeds, competition, recent signals, trajectory). Use it to disambiguate providers before making claims about them.
    ConnectorNo auth
  • Identify exactly which TaScan server and schema this MCP session is talking to. Call this FIRST when diagnosing anything — it makes "dev server masquerading as production" and "is my fix deployed yet" one tool call instead of an inference.
    ConnectorNo auth
  • Provision a Floot-managed backend resource for the project — fully server-side (Floot mints all secrets; no keys to paste). Also seeds the working code for it. Available: - database — A Floot-managed Postgres database (Neon). FLOOT_DATABASE_URL is set for the app. - auth — Email/password + session auth (JWT_SECRET, auto-provisions a database if none). Injects auth pages, endpoints, and helpers. - oauth-login — Sign in with Google via Floot's brokered OAuth (FLOOT_OAUTH). Injects OAuth provider classes, login buttons, helpers. - microsoft-login — Sign in with Microsoft via Floot's brokered login (FLOOT_MICROSOFT_LOGIN). Injects button + auth endpoints. - google-integration — Google API access (Gmail/Calendar/etc.) via Floot's brokered Google OAuth (FLOOT_GOOGLE_INTEGRATIONS). Injects Connect button + endpoints. - microsoft-integration — Microsoft Graph access (Outlook/Teams/etc.) via Floot's brokered Microsoft OAuth (FLOOT_MICROSOFT_INTEGRATIONS). Injects Connect button + endpoints. - push-notifications — Web + native push (FLOOT_PUSH). Mints VAPID keys, injects helpers/pushClient (subscribe/unsubscribe) + a service worker. Enum values not listed above are beta-gated and unavailable on most accounts. SENDING email from the app is NOT a resource — the builtin @floot/email handles it with zero setup (get_guides("email")). For a user's OWN external key (their OpenAI key, an external database), this is NOT the tool — use request_external_resource instead. Idempotent: re-running returns the existing resource and skips seed files that already exist.
    ConnectorOAuth
  • Returns all 12 Berlin boroughs (Bezirke) with IDs and names. Key response fields: array of { bezirk_id, bezirk_name } - bezirk_id: 2 digits ("01" to "12") - bezirk_name: e.g. "Mitte", "Friedrichshain-Kreuzberg", "Pankow" Use when: - You need an overview of Berlin's administrative structure - You need a bezirk_id for market data queries Do NOT use when: - You already know the bezirk_id → use berlin_borough_details directly
    ConnectorNo auth
  • Saves exactly five unique dashboard panels as the workspace Overview and returns the saved configuration. Use when the user asks to change which panels their Overview shows. Repeating a request with the same idempotency_key replays the original result instead of saving again. When the account's access has lapsed, it returns an access recovery response instead of saving.
    Connector
    Destructive
    OAuth
  • List running processes on an agent-managed device — live read via the agent tunnel. Wraps POST /api/getDeviceProcesses (permission: devices). Returns rows as reported by GETPS: (process id, name, parent, memory, etc. — exact shape depends on the agent version). Common diagnostic patterns: pair with agent_services to answer 'is the SQL Server service running but stuck?'; correlate top memory/cpu processes with eventlog_search criticals. Read-only by design — the process-kill endpoint (KILLPS) is deliberately NOT exposed via mcpmond. Server-side timeout is 60s; expect 400 if the device is offline or not enrolled. Example: agent_processes({device_id: 42})
    ConnectorNo auth
  • Create a new or update an existing Microsoft Ads (Bing) text ad on the Metadata platform. IMPORTANT: This tool is ONLY for Microsoft Ads (MICROSOFT_ADS channel) text ads. Ad library entries are PER-CHANNEL: a Google RSA can NOT be attached to a Microsoft Ads channel, and vice versa. Building the "same" ad for both channels means two calls, one per tool. For Google Ads text ads use create_update_google_ads_ad. Do NOT use this tool for Facebook, LinkedIn, Instagram or Reddit ads: use create_update_image_ad (IMAGE/GIF) or create_update_video_ad (VIDEO). ALSO KNOWN AS: Microsoft Ads text ad, Bing text ad, Bing search ad, MS Ads ad, Microsoft responsive search ad BEHAVIOR: - If "id" is NOT provided -> creates a new Microsoft Ads text ad. - If "id" IS provided -> updates the existing Microsoft Ads text ad with that ID. CHARACTER LIMITS (HARD LIMITS — THE API REJECTS ANYTHING OVER) Microsoft Ads and Google Ads share one text-ad shape on the platform, so the limits are identical: - Headlines: MAXIMUM 30 characters each (minimum 3, maximum 15 headlines) - Descriptions: MAXIMUM 90 characters each (minimum 2, maximum 4 descriptions) - Ad name: MAXIMUM 50 characters DESCRIPTIONS — 90 CHARACTER HARD LIMIT — READ THIS CAREFULLY THIS IS THE #1 MOST COMMON FAILURE MODE. - 90 characters is an ABSOLUTE ceiling. 91 = REJECTION. 89 = OK. - EVERY character counts: letters, digits, spaces, punctuation, apostrophes, hyphens, line breaks, emoji. - The MCP schema enforces maxLength=90, and the server truncates as a backstop, so over-length copy is either rejected outright or SILENTLY CUT MID-SENTENCE. - Target 70-85 characters per description. Do not write to the cliff. - LLMs systematically underestimate length by 5-15 characters. ALWAYS COUNT, never estimate. EVERY HEADLINE AND EVERY DESCRIPTION MUST BE UNIQUE The platform rejects the WHOLE ad when two headlines carry identical text ("Enter a headline that is different from: '<text>'"), and applies the same rule to descriptions. Writing 12 real headlines plus 3 near-copies of them is the second most common rejection. Make every line genuinely different. NO EXCLAMATION MARK IN A HEADLINE "!" is rejected in headline text ("! is not supported"). Descriptions accept it. DYNAMIC KEYWORD INSERTION A headline may use the "{KeyWord:fallback text}" form; the platform measures the 30-character limit against the fallback text inside the braces. MANDATORY PRE-CALL VALIDATION — DO THIS BEFORE EVERY CALL: 1. Count each headline: every one MUST be 30 characters or fewer, and free of "!". 2. Count each description: every one MUST be 90 characters or fewer. 3. Check for repeats across headlines, and across descriptions. Rewrite any duplicate. 4. Rewrite anything over the limit BEFORE calling. Do not submit known-bad copy and hope. USAGE INSTRUCTIONS FOR LLM: Use this tool when users want to: - Create a new Microsoft Ads / Bing text ad - Update an existing Microsoft Ads text ad (headlines, descriptions, or name) - Give a Microsoft Ads campaign the ad it needs to become launch-ready WHEN TO USE: - User asks "create a Microsoft Ads ad" / "Bing ad" / "MS Ads search ad" - A campaign has Microsoft Ads enabled and the channel has no ad yet - User says "update Microsoft ad 23149 with new headlines" WHEN NOT TO USE: - User wants the Google Ads version of the ad -> use create_update_google_ads_ad - User wants a Facebook, LinkedIn, Instagram or Reddit IMAGE ad -> use create_update_image_ad - User wants a Facebook, LinkedIn, Instagram or Reddit VIDEO ad -> use create_update_video_ad - User wants a sitelink, callout or other extension -> use the create_microsoft_*_extension tools INPUT PARAMETERS: - id: The ad ID (optional). If provided, that ad is updated. If omitted, a new ad is created. This is the adLibraryId inside the creatives of the microsoft channel in a campaign response. - name: The name/label for the ad (required, max 50 characters) - headlines: Array of headline text strings (required, minimum 3, maximum 15, each STRICT MAX 30 CHARACTERS, all distinct, no "!") - descriptions: Array of description text strings (required, minimum 2, maximum 4, each STRICT MAX 90 CHARACTERS, all distinct) EXAMPLE USAGE (Create): create_update_microsoft_ads_ad( name="Bing Hosting Q1 2026", headlines=["EU Data Centers", "Local Expert Support", "Hosting Built For Founders"], descriptions=["Keep your business data in Europe.", "2000+ local experts, one platform."] ) EXAMPLE USAGE (Update): create_update_microsoft_ads_ad( id=23149, name="Bing Hosting Q1 2026 v2", headlines=["Updated Headline 1", "Updated Headline 2", "Updated Headline 3"], descriptions=["Updated description one.", "Updated description two."] )
    Connector
    Destructive
    API key
  • Find observation variables (traits) by name, trait class, ontology term, or free-text query. Free-text queries are ranked against the returned set and may resolve to ontology URIs when the server advertises them. When the upstream total exceeds loadLimit, the full result set is materialized as a dataframe — query it with brapi_dataframe_query (SQL).
    ConnectorNo auth