📘 English | 简体中文 | 繁體中文 | 日本語 | 한국어 | Deutsch | Français | Italiano | Português | Español | Русский



apiSQL

API development = One SQL

Rapidly turn your database into a REST API and MCP Server, proxy any API, and achieve enterprise-grade security protection.

Docs Editions Website

apiSQL is a powerful platform for API development and management. With its built-in API Gateway supporting secure tunneling, you can easily proxy any internal or external API, or connect to databases and expose them as APIs or MCP Servers (Model Context Protocol) with enterprise-grade security—faster, simpler, and safer than building from scratch.


💡 The Origin of apiSQL

apiSQL started as a simple internal tool to quickly expose MySQL's SELECT, INSERT, UPDATE, DELETE as APIs.

For example: to develop a query API:

SELECT * FROM area

This generates an API supporting both GET and POST methods. Demo URL (public, no auth):

https://open.apisql.cn/api/demo-area/all

Paginate the result (page 2, 10 rows per page, 30s timeout):

https://open.apisql.cn/api/demo-area/all?meta[pageNum]=2&meta[pageSize]=10&meta[timeout]=30

You can also: sort fields, export to Excel/CSV, define environments, and debug in a built-in Postman-style interface—parameters auto-generated, no switching tools.



Example of an upsert API with MySQL:

INSERT INTO `user_upsert` (id, name, age) 
VALUES 
  (:id, :name, :age)
ON DUPLICATE KEY UPDATE 
  id = VALUES(id),
  name = VALUES(name),
  age = VALUES(age);



Custom function API to calculate city distance:

SELECT calc_city_distance(:name1, :name2) AS distance_desc;



Call a stored procedure to create a transfer transaction API:

CALL transfer_funds(:from_account_id, :to_account_id, :amount)



Simple. Elegant. Efficient.

With continued use, we realized: the database is the ultimate backend.

Why reinvent the wheel? Leverage the battle-tested performance, stability, and power of databases by exposing them securely and directly as APIs.

apiSQL has evolved from a lightweight internal tool to a full-featured API platform:



✨ Key Features

🗄️ Multi-Database Support

⚙️ Rapid API Generation

🧩 Script Extensibility

🛡️ Enterprise-Grade Gateway & Security

🤖 AI-Ready Integration



🚀 Get Started

  1. Try Now: Visit apisql.cn and register for a free trial
  2. Read the Docs: Follow the Quick Start Guide
  3. Choose Your Deployment:
  4. SaaS: Zero setup, instantly usable, scalable cloud version
  5. Free Private Version: Download here and deploy on your server



📦 Editions

Edition For Deployment Key Features
Free Individuals, Small Teams Self-hosted Core API functionality
Pro Pro Devs, Mid-size Teams Self-hosted Advanced features
Enterprise Large Organizations Self-hosted Multi-project, multi-user, full-stack
SaaS Everyone Cloud-hosted Hassle-free, ready-to-use, pay-as-you-go

👉 View full comparison

⚠️ Please Note
apiSQL provides a fully functional free version for self-hosted and commercial use, but the project is not open-source.



🛣️ Roadmap



🔗 Links