API Database Layer Generated From Your SQL Schema
Upload your SQL DDL or Prisma schema and get REST, GraphQL and MCP endpoints over your existing tables, with validation, relations, docs, keys and tests.
Your generated API
https://clinic.apigenerator.ai
- Parsing source
- Inferring resources
- Designing endpoints
- Writing docs
- Building MCP tools
Request
Response
Create your account to see every resource, run the tests, export the code and deploy this API.
What APIGenerator reads from your schema
- Tables, columns and types for PostgreSQL, MySQL and SQLite.
- Primary keys, foreign keys and unique constraints.
- Nullable and default values, which become validation rules.
- Prisma models and relations.
CREATE TABLE orders (
id uuid PRIMARY KEY,
customer_id uuid REFERENCES customers,
status text NOT NULL,
total numeric(10,2),
placed_at timestamptz
);
From tables to a documented API
-
A resource per table with list, read, create, update and delete.
-
Relations from foreign keys, with nested routes and expandable fields.
-
Hidden columns you choose, such as password hashes or internal flags.
-
REST, graphql api and MCP output from the same schema.
-
Docs, contract tests and a mock server.
Your data stays where it is
Only the schema is used to generate the API. When you export the code and run it next to your database, the data never leaves your infrastructure. For agents, see the postgres mcp server.
Questions about database to api
No. APIGenerator needs only the schema. Your rows stay in your database.
Yes. Exclude any table or column before you deploy, and it never appears in the API, docs or MCP tools.
Upload the new schema and APIGenerator updates the endpoints, docs, tests and tools. Breaking changes can ship as a new API version.
Put an API on your database
Upload your SQL schema and see the endpoints in seconds.