# API Creator

> API Creator is three companion modules — DB to API, Mock API, and Script to API. Each ships an endpoint without a separate codebase, pod, or CI/CD wait, and each passes the same gateway pipeline as a hand-written service.

*API Creator — three ways to skip the microservice*

## Some endpoints don't need a service. Stop building them anyway.

[Request a demo](https://calendly.com/apinizer/15min) · [Read the docs](https://apinizer.com/developers/docs)

**Highlights**

- **DB to API** — 10 databases · SELECT/INSERT/UPDATE/DELETE/PROCEDURE/BATCH
- **Mock API** — OpenAPI import · condition-driven branching
- **Script to API** — JavaScript on GraalVM · Groovy 3.0

---

## Capabilities

### DB to API — SQL queries become endpoints

Write a SELECT, INSERT, UPDATE, DELETE — or call a stored procedure with cursor results. Apinizer publishes it as a REST endpoint with parameter binding, response shaping, and the gateway's full policy stack. Works across 10 databases out of the box.

- Oracle · PostgreSQL · MySQL · MSSQL · DB2 · Sybase · Hive · Impala · Trino · MongoDB
- Stored procedures with REF_CURSOR and OUT parameters
- BATCH_INSERT for bulk writes from a JSON array
- Response shaping: ignore null, ISO 8601 dates, big-int as string

### Mock API — frontends shouldn't wait on backends

A mock that enforces real auth, branches on the live request, and lands in the same audit log as production. Author bodies for every status code, import OpenAPI to bootstrap, promote in place when the upstream is ready.

- Multiple example bodies per status code with custom headers
- Condition-driven routing — header, JSONPath, JWT claim, cookie
- Bootstrap from OpenAPI in one step
- Same auth, throttle, audit, and analytics as live proxies

### Script to API — twelve lines beats a microservice

JavaScript on GraalVM Polyglot or Groovy with full Java interop. Apinizer compiles at deploy time, dispatches lock-free, and exposes the script as a real endpoint with the gateway's pipeline wrapped around it.

- JavaScript: GraalJS 24.2.1 with HostAccess.ALL
- Groovy: 3.0.25 pre-compiled to Class — no warm-up cost
- Bindings: request, http, db, vars — no imports needed
- Save → live URL in under three seconds, with full audit trail

---

## Use cases

### Ship a real API in an afternoon

Connect a database, write a query, expose it. The frontend team has something to call before the backend ticket is groomed.

- DB to API for read endpoints
- Mock API for write endpoints
- Promote each path independently when the upstream lands

### Expose database data without a microservice

Turn the table that backs a legacy system into a modern REST endpoint. No new service to run.

- Stored procedure as endpoint with cursor results
- Read replica routing for read-heavy paths
- Per-endpoint quotas and cache TTL

### Drop a script where you'd otherwise build a service

Need to enrich a request, call an external API, and combine the result? Write Groovy or JavaScript and ship it.

- External API calls in script via http.*
- Database calls in script via db.query
- Same observability as native code

---

## What ships in the box

### DB to API

- 10 first-class databases + any JDBC driver
- SELECT / INSERT / UPDATE / DELETE / PROCEDURE / BATCH_INSERT
- Named parameter binding from PATH/QUERY/HEADER/BODY
- Stored procedure cursor unwrapping

### Mock API

- Every HTTP verb, every status code, custom headers
- Condition engine with header/JSONPath/JWT/cookie matchers
- OpenAPI import for one-step scaffolding
- Promote any mock path to a real proxy without URL change

### Script to API

- JavaScript on GraalVM Polyglot
- Groovy 3.0 with full Java interop
- request / http / db / vars bindings out of the box
- Save-to-live in under three seconds with audit trail

### Pipeline integration (all three)

- Same auth surface as gateway proxies (OAuth 2.0 / JWT / API key / mTLS)
- Throttling, quotas, IP allow-lists, scope-based access
- Cache, audit log, Elasticsearch analytics, Prometheus metrics
- APIops manifests for CI/CD

---

## Resources

- [DB to API](https://apinizer.com/products/db-to-api) — Turn SQL queries and stored procedures into REST endpoints.
- [Mock API](https://apinizer.com/products/mock-api) — Real-shaped responses with conditional branching and full auth.
- [Script to API](https://apinizer.com/products/script-to-api) — JavaScript or Groovy as an endpoint, with the full pipeline.
- [API Creator docs](https://apinizer.com/developers/docs) — Reference material for all three Creator modules.
- [Architecture](https://apinizer.com/products) — How Creator endpoints sit on Worker with the same pipeline.

---

## Next step

*Skip the microservice*

**Three ways to ship an API without a service.**

DB to API, Mock API, Script to API — see all three on real data in a 30-minute walkthrough.

[Book a Demo](https://calendly.com/apinizer/15min) · [Read the docs](https://apinizer.com/developers/docs)

---

## Links

- Products: https://apinizer.com/products
- AI Gateway: https://apinizer.com/products/ai-gateway
- Solutions: https://apinizer.com/solutions
- Pricing: https://apinizer.com/pricing
- Developers: https://apinizer.com/developers
- Documentation: https://docs.apinizer.com/index-en
- Blog: https://apinizer.com/blog
- Contact: https://apinizer.com/company/contact

© 2026 Apinizer. All rights reserved.