{ }InstantAPI

SQL Server REST API

Turn SQL Server into a REST API, instantly

Skip writing controllers and hosting an API layer. Connect Microsoft SQL Server or PostgreSQL and get CRUD endpoints for every table.

  • GET, POST, PUT and DELETE per table
  • Paging and filters built in
  • Custom parameterized SQL endpoints
  • Relational ER schema graph
Start 30 days freeRead the quickstart

CRUD for every table

Schema reflection creates read and write endpoints for each table and view you enable.

bash
curl -X POST "https://api.instantapi.app/api/s/{short_code}/rows" \
  -H "Content-Type: application/json" \
  -d '{"name":"Ada"}'

Custom SQL as an API

Write a query in the SQL Editor, add parameters, and deploy it as its own endpoint.

See who calls it

Traffic logs show requests and caller IPs so you know how your endpoints are used.

Frequently asked questions

How do I turn a SQL Server table into a REST API?
Connect your SQL Server in InstantAPI. Every table gets CRUD endpoints with an 8-character TinyURL, with no code to write or host.
Does it support PostgreSQL too?
Yes. SQL Server and PostgreSQL both work the same way.
Can I publish custom SQL as an endpoint?
Yes. Save a parameterized query as a Custom API and it gets its own short link.