--- title: "On-Premises Data Gateway Alternative | Runs on Mac & Linux | Agent UI" description: "An on-premises data gateway alternative for SQL Server: a read-only connector that runs on Windows, macOS or Linux and feeds apps and AI you build in AgentUI." url: https://www.agentui.ai/en/on-premises-data-gateway-alternative/ lang: en source: en/on-premises-data-gateway-alternative/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-premises-data-gateway-alternative/](https://www.agentui.ai/en/on-premises-data-gateway-alternative/) — 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) Windows, macOS or Linux # An on-premises data gateway alternative that also runs on Mac and Linux On-premises data gateway alternatives come up for two reasons: there's no spare Windows machine next to the SQL Server, or you need apps, not reports. The AgentUI Connector installs on Windows, macOS or Linux, reads your database over one outbound HTTPS connection, and feeds the apps and AI you build in AgentUI. [Connect my SQL Server](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Walk through it with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) It only reads, and you can revoke it in two clicks. Your connectors2 onlineWarehouse DB (on-prem)Microsoft SQL Server · Linux serviceOnlineAccounting SQL (on-prem)Microsoft SQL Server · Windows serviceOnlineLab server (on-prem)Microsoft SQL Server · macOS serviceOfflineDirectionOutboundAccessRead-onlyPer query1,000 rows ## AgentUI Connector vs. Microsoft On-premises Data Gateway | | AgentUI Connector | Microsoft gateway | | --- | --- | --- | | Connection | Outbound only, HTTPS on port 443 | Outbound only, through Azure Relay | | Runs on | Windows, macOS, Linux | Windows only | | Data sources | Microsoft SQL Server only | Many sources, SQL Server included | | Feeds | Apps and AI you build in AgentUI | Power BI, Power Apps, Power Automate, Logic Apps, Analysis Services | | Writes | Never. It only reads. | Depends on the product using it (Power Apps can write) | | Install | .exe, .pkg or .deb, or one command | Windows installer | Neither needs an inbound firewall rule, since both connect out. What changes is which machine it can run on and what it can feed. ## Why teams look beyond the Power BI gateway ### There's no Windows machine to spare The gateway needs a Windows machine. The connector also runs on the Linux or macOS machine already on that network. ### You need an app, not another report Build a stock screen, a customer lookup or an approvals list on top of SQL Server, and ask the AI questions about the same data. ### IT wants one read-only path The connector can only read, and the database password never leaves the server. ### Nobody on the team wants to own it One of us walks your IT through the install, so the setup doesn't live in one colleague's head. ## Connect your SQL Server in three steps 01 ### Install it next to the database Double-click the .exe, .pkg or .deb, or paste one command. No Node.js needed. 02 ### Create the connector in AgentUI In AgentUI, open Connect Apps → SQL Database and click Create connector. It gives you one command to run on the server. 03 ### Check it's online Your connection shows up as " (on-prem)". If the server reboots or the service crashes, it restarts itself. ## What IT will want to check - The database password never leaves that server, and on Windows it's stored encrypted. AgentUI only holds a fingerprint of the connector key. - It can run SELECT and WITH queries and nothing else, and it rolls each one back when it finishes. - Two clicks revoke a connector, and its key stops working within 25 seconds. - The Your connectors page shows which servers are online. ## When to keep the on-premises data gateway Keep it if your reports live in Power BI, if you pull from Oracle, files or other sources besides SQL Server, or if Power Apps needs to write back to the database. The connector does none of those. The two are separate services, so you can keep the gateway for Power BI and add the connector for the apps you build in AgentUI. ## What the connector won't do - It reads Microsoft SQL Server only. MySQL, PostgreSQL or Oracle on your network won't work. - Each query returns up to 1,000 rows and runs for up to 30 seconds. Nothing is copied or kept in sync. - One workspace holds up to 20 connectors, so each server or site can have its own. ### Related - [How the on-premise SQL Server connector works](/en/on-premise-sql-server-connector/) - [SAP Business One and Power BI: what you need](/en/sap-business-one-power-bi/) - [SAP Business One dashboards with no open ports](/en/sap-business-one-dashboard/) - [Retool and an on-premise SQL Server: the options compared](/en/retool-on-premise-sql-server/) - [A simpler alternative to Excel-to-Power BI](/en/excel-to-powerbi-alternative/) - [Every AgentUI integration](/en/integrations/) ## Connect your SQL Server from the machine you already have Your IT person gets a step-by-step Word guide with screenshots. If they'd like company for the install, we'll join the call. [Connect my SQL Server](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Walk through it with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) It only reads, and you can 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