Back
Microsoft SQL Server Wrapper
Overview
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft. It's used by enterprises worldwide for transactional workloads, analytics, and mission-critical applications, with SQL Server 2025 adding built-in AI capabilities, vector search, and native JSON support.
The SQL Server Wrapper brings your SQL Server tables and views into Postgres as queryable foreign tables. Query data with plain SQL, use subqueries in table definitions, and take advantage of pushdown for where, order by, limit, and aggregate clauses — so queries run on SQL Server, not locally. Read-only, and works with Supabase Vault for secure connection string management.
Supported Data Types
| Postgres Type | SQL Server Type |
|---|---|
| boolean | bit |
| char | tinyint |
| smallint | smallint |
| real | float(24) |
| integer | int |
| double precision | float(53) |
| bigint | bigint |
| numeric | numeric / decimal |
| text | varchar / char / text |
| date | date |
| timestamp | datetime / datetime2 / smalldatetime |
| timestamptz | datetime / datetime2 / smalldatetime |
Resources
Details
Third-party integrations and docs are managed by Supabase partners.