Guide

SQL Server Endpoint

SQL Server endpoints connect Gateway to Microsoft SQL Server and SQL Server-compatible services for governed T-SQL access and operational planning.

Endpoint Kind

Use mssql as the endpoint kind when creating this endpoint through the API or dashboard.

What Gateway Uses This Endpoint For

Run governed T-SQL queries through Gateway.
Expose SQL Server data to AI Orchestration and approved tools through RBAC.
Inventory databases, schemas, tables, views, indexes, and stored procedures.
Plan modernization from SQL Server to another relational target.

Basic Endpoint Shape

json

{
  "endpoint": "sqlserver-prod",
  "kind": "mssql",
  "config": {
    "read_conn": {
      "host": "sqlserver.internal",
      "port": 1433,
      "database": "appdb",
      "auth": {
        "username": "app_user",
        "password": "secret"
      }
    }
  }
}

Create it with the endpoint API:

bash

curl -sS -X POST "$EDEN/endpoints" \
  -H "$AUTH_HEADER" \
  -H "Content-Type: application/json" \
  -d '{
  "endpoint": "sqlserver-prod",
  "kind": "mssql",
  "config": {
    "read_conn": {
      "host": "sqlserver.internal",
      "port": 1433,
      "database": "appdb",
      "auth": {
        "username": "app_user",
        "password": "secret"
      }
    }
  }
}'

Configuration Fields

Field	Purpose
`host`	SQL Server host
`port`	SQL Server port, usually 1433
`database`	Database name
`username`	Login name
`password`	Login password

Operating Notes

Validate encryption and certificate requirements for production SQL Server deployments.
Use least-privilege logins scoped to the required database.
Document collation, compatibility level, and stored procedure dependencies before migration planning.