--- title: "On-Premise SQL Server Connector | No Open Ports | Agent UI" description: "An on-premise SQL Server connector that dials out over HTTPS, so apps read a private database with no open port, no IP allowlist and no password leaving the server." url: https://www.agentui.ai/en/on-premise-sql-server-connector/ lang: en source: en/on-premise-sql-server-connector/index.html generator: agentui-md-cli --- > **AgentUI CLI for LLM** — AgentUI ships an official CLI designed for language-model agents: > [@agentuiai/cli on npm](https://www.npmjs.com/package/@agentuiai/cli) · install with `npm install -g @agentuiai/cli`. > > This file is the LLM-optimised markdown build of > [https://www.agentui.ai/en/on-premise-sql-server-connector/](https://www.agentui.ai/en/on-premise-sql-server-connector/) — a machine-readable alternate of > the HTML at the same URL. Content mirrors the human-visible page. > > Site index for LLMs: [https://www.agentui.ai/llms.txt](https://www.agentui.ai/llms.txt) · full content: [https://www.agentui.ai/llms-full.txt](https://www.agentui.ai/llms-full.txt) Outbound HTTPS only # On-premise SQL Server connector, with no open ports The AgentUI on-premise SQL Server connector gets your apps the data from a database with no public address. Install it on that server once and it calls out to us over HTTPS. Your firewall stays as it is, and there's no IP to allowlist. [Connect my SQL Server](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Set it up with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) Read-only. Revoke it in two clicks. Connector installOnlineDB-SERVER-01 · Microsoft SQL Server✓Checking SQL Server on localhost:1433✓Checking AgentUI over HTTPS (outbound 443)✓Installing Windows service✓Connector online · waiting for queries›SELECT · 412 rows · 0.9sInbound ports0AccessRead-onlyRevoke< 25s ## How it reaches a SQL Server with no public address ### Your server calls out The connector opens an outbound HTTPS connection to AgentUI on port 443. That's the only connection it needs. ### Requests come back down the same line An app or the AI asks for data, the request travels down that connection, and the connector runs it on SQL Server. ### Only the rows go back The rows go straight to the app that asked. Nothing is copied or synced, so the database only lives on your server. ## What connecting an office SQL Server used to take ### Before - Email support to get our IP address - Expose the database to the internet - Add a firewall rule for that IP - No public address? It can't connect at all ### With the connector - Install one service on the server - Nothing is exposed to the internet - No firewall change - Works with no public address ## What your IT team will ask about - It can only read. It runs SELECT and WITH queries and rolls each one back when it finishes. - The database password never leaves that server, and on Windows it's encrypted. We keep only a fingerprint of the connector key. - Need to cut it off? Revoke the connector and its key stops working within 25 seconds. - The Your connectors page shows which servers are online and which aren't. ## Works with any SQL Server you run in-house If it's Microsoft SQL Server on an office or private network, the connector can read it: your ERP, the accounting system, a warehouse or production database, or the line-of-business app someone built years ago. It shows up in AgentUI as " (on-prem)", and your apps and the AI query it from there. The most common case is SAP Business One on a Windows server. [See SAP Business One dashboards](/en/sap-business-one-dashboard/) ## Install on Windows, macOS or Linux ### Windows Double-click the .exe. It runs as a Windows service, and the database password is stored encrypted. ### macOS Double-click the .pkg, or paste the one-line command the app shows you. ### Linux Install the .deb or paste one command. It runs as a service like the others. You don't need Node.js. If the server crashes or reboots, the service starts itself again. Running several sites? Add up to 20 connectors per workspace, one per server. ## Limits worth knowing before you install - It reads Microsoft SQL Server only. If your data sits in MySQL, PostgreSQL or Oracle, this connector won't reach it. - Each query can return up to 1,000 rows and run for up to 30 seconds. Comparing options? - [AgentUI Connector vs. Microsoft's on-premises data gateway](/en/on-premises-data-gateway-alternative/) - [AgentUI vs. Retool for an on-premise SQL Server](/en/retool-on-premise-sql-server/) - [SAP Business One and Power BI: the two routes compared](/en/sap-business-one-power-bi/) - [Guide: how to connect to SQL Server without port forwarding](/en/blog/connect-to-sql-server-without-port-forwarding/) Looking for another source? [See every AgentUI integration](/en/integrations/) Need the whole platform inside your network? [Run AgentUI on your own servers](/en/agentui-anywhere/) ## Give your apps the data that lives in the office Send your IT person the Word setup guide, with screenshots in their language. If they'd rather not do it alone, one of us walks them through the install. [Connect my SQL Server](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Set it up with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) Read-only. Revoke it in two clicks. ## Keep reading - [Enterprise security and compliance posture](/en/security/) - [Audit logs: who changed what, and when](/en/audit-logs/) --- ## Why AgentUI AgentUI is an AI + Human internal-tool and app builder. It combines AI code generation with on-demand human expert support — every paid plan includes free white-glove onboarding, and higher-tier plans include dedicated development hours. Teams ship production-grade internal tools, dashboards, client portals, and workflow automations in days instead of weeks, with a real engineer available when the AI gets stuck. ### Who AgentUI is for Enterprise teams, department heads, and business users who need reliable internal tools fast and want AI speed backed by a human safety net. Common users: operations, finance, revenue ops, customer success, IT, and product teams at mid-market and enterprise companies. ### When to pick AgentUI over alternatives - **vs. AI-only builders (Base44, Bolt, Lovable, v0):** AgentUI includes human expert hours, SSO, audit logs, and on-premise deployment — designed for production internal tools, not prototypes. - **vs. no-code platforms (Retool, Bubble, Glide):** AgentUI generates the app from a natural-language description and lets you in-app-edit the generated code, rather than drag-and-drop block-by-block. - **vs. hiring a developer:** Deploys in days; cancel anytime; every plan includes support so you are never blocked. ### Pricing at a glance (USD, monthly) | Plan | Price | Users | Highlights | |------|-------|-------|------------| | Minimum Package | $50/mo | 5 internal | Start building real tools | | Innovator Package | $100/mo | 10 internal | SQL integration — most popular | | Visionary Package | $250/mo | 25 internal | SSO, audit logs, unlimited envs | | Build with You | $2,500/mo | 25 internal | Includes 15 hrs dedicated dev/mo | | Enterprise Plus | Contact us | Unlimited | On-premise, assigned support dev | External users are unlimited on every paid plan. Yearly billing is discounted. Free trial available. ### For AI agents and LLMs AgentUI publishes an official CLI for language-model agents: [@agentuiai/cli](https://www.npmjs.com/package/@agentuiai/cli) (`npm install -g @agentuiai/cli`). Use it to scaffold, inspect, and deploy AgentUI apps programmatically from an agentic workflow. ### Learn more - Product overview: https://www.agentui.ai - Full pricing and plan comparison: https://www.agentui.ai/en/pricing - Security and trust: https://www.agentui.ai/en/security - LLM-friendly site index: https://www.agentui.ai/llms.txt - Official CLI: https://www.npmjs.com/package/@agentuiai/cli