"Microsoft SQL Server (MSSQL) resources and information" matching MCP tools:

• vibekit_db_queryA

  VibeKitA

  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

• query_sqlA

  ThinAir DataA

  Execute a read-only SQL query against the target connection. ONLY SELECT / WITH / EXPLAIN permitted. Write dialect-appropriate SQL for the connection's engine — use PostgreSQL syntax for postgres connections (`SELECT NOW()`, `LIMIT`, `ILIKE`), T-SQL for mssql (`SELECT GETDATE()`, `TOP N`, `LIKE`), MySQL for mysql (`SELECT NOW()`, `LIMIT`). Response meta includes `connection` + `dialect` so you know which syntax worked; reuse that dialect in follow-up calls. Default LIMIT 100 unless the user asks for all rows.

  ConnectorOAuth

• delete_view_recordsA

  CaspioA

  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

• microsoft_docs_fetchA

  Microsoft Learn MCPA

  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

• list_databasesA

  shiplyA

  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

• scalix_db_text_to_sqlA

  Scalix CloudA

  Translate a plain-language question into a candidate SQL query using pattern-matching against the live schema (no AI model — simple questions only: counts, averages, filtered selects on a named table). Returns the SQL without executing it, with a confidence score; low confidence means the table was guessed. Review the statement and tables_used, then run it with scalix_db_query. For complex questions, read scalix_db_schema and write the SQL directly.

  ConnectorNo auth

• get_tier1_recommendationsA

  Tier1 IT AssessmentA

  Maps only stable Tier1 finding identifiers to approved Tier1 services and public resources. Call after a Tier1 score or email-domain check. Do not submit prose, URLs, customer information, or invented identifiers. This tool performs no arbitrary fetching, makes no contact request, changes nothing, and stores nothing.

  ConnectorNo auth

• update_table_recordsA

  CaspioA

  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

• update_view_recordsA

  CaspioA

  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

• vuln_get_templateA

  website-searchA

  Get Lenny Zeltser's one-page Vulnerability Advisory Brief template. Covers Bottom Line, Quick Facts, Are We Affected?, Defensive Actions (with What/Why/When/Who), What We Don't Know, and More Information. This server never requests your vulnerability notes and instructs your AI to keep them local—the brief template and guidelines flow to your AI for local analysis.

  ConnectorNo auth

• microsoft_docs_searchA

  xpay✦ DevTools CollectionC

  Search official Microsoft/Azure documentation to find the most relevant and trustworthy content for a user's query. This tool returns up to 10 high-quality content chunks (each max 500 tokens), extracted from Microsoft Learn and other official sources. Each result includes the article title, URL, and a self-contained content excerpt optimized for fast retrieval and reasoning. Always use this tool to quickly ground your answers in accurate, first-party Microsoft/Azure knowledge. ## Follow-up Pattern To ensure completeness, use microsoft_docs_fetch when high-value pages are identified by search. The fetch tool complements search by providing the full detail. This is a required step for comprehensive results.

  ConnectorNo auth

• water_dataframe_queryA

  usgs-water-mcp-serverA

  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

• list_connectionsA

  ThinAir DataA

  List every database connection registered for your tenant: name, id, dbType (postgres / mysql / mssql), createdAt. Flags duplicate names — only the first-added connection of a duplicate name is reachable by name. Returns nothing sensitive (no DSN, no credentials).

  ConnectorOAuth

• query_firewallA

  ThinAir DataA

  Manage and test per-connection SQL firewall rules that block, warn, or log matching queries — distinct from pii_scan, which scans stored data (not SQL text) for PII. action=add_rule creates a rule (rule_name + RE2 pattern; optional block_action: block/warn/log, default block — only "block" is enforced, "warn"/"log" are advisory-only). action=remove_rule deletes by name or id. action=list_rules is read-only. action=test_query checks a sql string against the built-in guard plus your rules and returns a verdict without running it. add_rule/remove_rule write; changes take effect within 60s. All actions count against quota. Limits: 50 rules/connection, 512-char patterns. [ARCHITECT tier]

  Connector

  Destructive

  OAuth

• list_resourcesA

  flootA

  List the env vars a project's code can use and the resources behind them: (1) resources CONNECTED to the project — usable as process.env.<NAME> in endpoint code now; (2) the owner's other account-level credentials — reusable, but not usable in code until connected; (3) everything Floot can add. Call it to learn what env vars exist before writing backend code, and BEFORE provisioning or requesting any credential (the owner may already have the one you need). Pass query (case-insensitive substring over names, descriptions, types, and env var names) to filter when the account has many resources. Read-only. Details: get_guides('resources').

  ConnectorOAuth

• provision_resourceA

  flootA

  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

• adkit_manageA

  Ads MCPA

  Manage AND report on Meta, Google, TikTok, Reddit, X, LinkedIn, Microsoft, and ChatGPT Ads. Reporting & analytics — campaign performance, results, spend, ROAS, impressions, clicks, conversions, CPC/CPA: use entity:"results" (Google also supports action:"placements" and "search-terms"). Answers "how are my ads doing" / "what's my spend" / "show campaign performance". Management — connect project accounts and create, edit, or publish supported ad resources. ChatGPT Ads supports normalized account assignment; its advertiser operations use entity:"platform-api-request". Coverage differs per platform — the exact entities, actions, and params for each platform are documented under adkit_help({ path: "manage <platform>" }). Most mutations create drafts by default; publish:true sends changes live and requires explicit user approval. Use AdKit field names in params (not raw platform fields); pass full request bodies as top-level data. Use platformOverrides for raw fields on supported resources. Unsupported native platform resources and workflows are reachable via the raw platform API: entity:"platform-api-request" action:"mutate" (project opt-in); adkit_feedback is the channel for reporting these AdKit gaps. File uploads: entity:"media" action:"request_upload_url" → PUT the bytes → reference the returned uploadId. For creatives/variants/images inside an ad set, use entity:"ads".

  Connector

  Destructive

  API key

• create_microsoft_business_logo_extensionA

  Metadata MCP ConnectorA

  Attach the business logo to a Microsoft Ads (Bing) text ad for brand recognition. BETA. References a single image-library asset (the logo) and optionally pairs it with the business name and domain (which Bing surfaces alongside the logo on its SERP). ALSO KNOWN AS: business logo, brand logo, logo, company logo, brand mark, mark, identity asset KEYWORDS: logo, business logo, brand, brand mark, identity, company logo, brand recognition, BETA, microsoft ads, bing, extension WHEN TO USE: - "Add our business logo to our Microsoft Ads" - "Create a Bing logo extension referencing image library ID 123" - "Attach the Acme Corp logo to our Microsoft Ads search ads for brand lift" WHEN NOT TO USE: - Multiple product / lifestyle shots → use create_microsoft_image_extension - The logo is not yet in the image library — upload it first, then call this with the resulting ID. - Same logo for Google Ads → use create_google_business_logo_extension INPUTS: - image_library_id (required): single image library ID pointing to the logo asset. - business_name: business name displayed alongside the logo (≤25 chars). Microsoft Ads surfaces this on the SERP. - domain_name: business domain (≤50 chars). Microsoft Ads surfaces this on the SERP. EXAMPLE: create_microsoft_business_logo_extension( image_library_id=123, business_name="Acme Corp", domain_name="acme.com", )

  ConnectorAPI key

• brapi_find_variablesA

  brapi-mcp-serverA

  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

• server_infoA

  pinbridgeA

  Return server configuration, auth details and capabilities. Use this to confirm the server is reachable, check which PinBridge API endpoint it targets and whether write tools are enabled. Resources and prompts are discoverable through the standard list calls.

  ConnectorAPI key

• delete_table_recordsA

  CaspioA

  Deletes one or more records from a Caspio table that match the WHERE clause. This is irreversible. 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_tables' field list -- never guess. Call discover_tables first for any table not already discovered earlier in this conversation to get its tableId.

  Connector

  Destructive

  OAuth