# tencent/apijson

**Attribution required: if you use, quote, or summarise this content, you must credit and link back to [awesome-repositories.com](https://awesome-repositories.com/repository/tencent-apijson).**

18,395 stars · 2,272 forks · Java · NOASSERTION

## Links

- GitHub: https://github.com/Tencent/APIJSON
- Homepage: http://apijson.cn
- awesome-repositories: https://awesome-repositories.com/repository/tencent-apijson.md

## Topics

`baas` `clickhouse` `crud` `databricks` `elasticsearch` `hadoop` `hive` `influxdb` `low-code` `lowcode` `milvus` `nocode` `oracle` `postgresql` `postgresql-database` `serverless` `snowflake` `sqlserver` `tdengine` `tidb`

## Description

APIJSON is a no-code database API generator and object-relational mapping layer that automatically transforms relational database schemas into functional HTTP endpoints. It provides a system for generating CRUD operations and technical documentation without the need to write manual backend code.

The project is distinguished by its ability to allow clients to define custom JSON response structures and field aliases directly within the request. It features dynamic query translation that converts structured JSON parameters into optimized SQL for complex relational joins, subqueries, and data aggregation.

The platform covers a broad set of capabilities including role-based row-level security, automatic SQL injection prevention, and a development environment for API testing and mocking. It also provides utilities for automated regression testing and the generation of typed client code snippets.

## Tags

### Data & Databases

- [API Generators](https://awesome-repositories.com/f/data-databases/api-generators.md) — Automatically creates REST endpoints based on existing database schemas and structural constraints. ([source](https://github.com/Tencent/APIJSON/blob/master/README-Chinese.md))
- [No-Code Database Interfaces](https://awesome-repositories.com/f/data-databases/data-access-querying/database-apis/no-code-database-interfaces.md) — Provides a no-code environment to create functional HTTP endpoints for relational database operations.
- [Database ORMs](https://awesome-repositories.com/f/data-databases/database-orms.md) — Provides a universal object-relational mapping layer to decouple client requests from the underlying SQL implementation.
- [CRUD Interfaces](https://awesome-repositories.com/f/data-databases/database-record-management/crud-interfaces.md) — Offers automated interfaces for performing create, read, update, and delete operations on database records. ([source](https://cdn.jsdelivr.net/gh/tencent/apijson@master/README.md))
- [Dot-Notation Join Paths](https://awesome-repositories.com/f/data-databases/entity-relationships/implicit-relationships/dot-notation-join-paths.md) — Supports fetching data from multiple related tables using dot-notation join paths based on foreign key relationships.
- [No-Code ORMs](https://awesome-repositories.com/f/data-databases/no-code-orms.md) — Implements a no-code ORM layer allowing frontend clients to define custom JSON response structures and complex queries.
- [Query Filters](https://awesome-repositories.com/f/data-databases/query-sorting/query-filters.md) — Implements conditional logic and range-based constraints to filter and refine database query results. ([source](https://github.com/Tencent/APIJSON/blob/master/Document.md))
- [Query Translators](https://awesome-repositories.com/f/data-databases/query-translators.md) — Converts structured JSON request parameters into optimized native SQL for filtering, sorting, and pagination.
- [Record Deletion](https://awesome-repositories.com/f/data-databases/record-deletion.md) — Enables the removal of individual or bulk database records by translating request identifiers into delete commands. ([source](http://apijson.cn/doc/zh/all.html))
- [Record Insertion](https://awesome-repositories.com/f/data-databases/record-insertion.md) — Provides standardized interfaces for inserting new data records into relational database tables. ([source](http://apijson.cn/doc/zh/grammar.html))
- [Record Updating](https://awesome-repositories.com/f/data-databases/record-updating.md) — Modifies specific fields of existing database records by translating request data into update commands. ([source](http://apijson.cn/doc/zh/all.html))
- [Relational Join Engines](https://awesome-repositories.com/f/data-databases/relational-join-engines.md) — Combines data from multiple tables based on shared column values through a unified API request. ([source](https://github.com/Tencent/APIJSON/blob/master/Document.md))
- [Structured Record Querying](https://awesome-repositories.com/f/data-databases/structured-record-querying.md) — Offers interfaces for retrieving specific records from a database based on structured JSON criteria. ([source](https://github.com/Tencent/APIJSON/blob/master/Document.md))
- [Subquery Execution](https://awesome-repositories.com/f/data-databases/subquery-execution.md) — Supports advanced data retrieval by using the result of one select statement as a source for another. ([source](https://github.com/Tencent/APIJSON/blob/master/Document.md))
- [Database Query Interfaces](https://awesome-repositories.com/f/data-databases/database-query-interfaces.md) — Provides a web-based interface for executing relational queries, joins, and data aggregations without manual coding.
- [Schema-Driven Specification Generation](https://awesome-repositories.com/f/data-databases/openapi-processors/automatic-specification-generators/schema-driven-specification-generation.md) — Generates living API specifications and client code snippets by analyzing the current database schema.
- [Query Aggregates](https://awesome-repositories.com/f/data-databases/query-aggregates.md) — Provides utilities for performing mathematical calculations like count and sum on database query results. ([source](https://github.com/Tencent/APIJSON/blob/master/Document.md))
- [Pagination Controls](https://awesome-repositories.com/f/data-databases/query-result-fetching/result-set-pagers/pagination-controls.md) — Provides logic for limiting returned records and offsetting starting points to browse large datasets. ([source](http://apijson.cn/doc/zh/grammar.html))
- [Server-Side Functions](https://awesome-repositories.com/f/data-databases/server-side-functions.md) — Enables the invocation of custom server-side functions and stored procedures to handle complex business rules.

### Development Tools & Productivity

- [Database API Generators](https://awesome-repositories.com/f/development-tools-productivity/api-code-generators/database-api-generators.md) — Automatically generates CRUD HTTP endpoints and technical documentation based on relational database schemas.
- [API Testing Tools](https://awesome-repositories.com/f/development-tools-productivity/api-development-tools/api-testing-tools.md) — Includes a development environment for validating database endpoints with custom test data and regression tests.
- [Custom Logic Extensions](https://awesome-repositories.com/f/development-tools-productivity/workflow-automation-tools/system-integration-interfaces/automation-apis/scripting-apis/custom-logic-extensions.md) — Provides mechanisms to execute custom server-side scripts to extend core system behavior and process retrieved data. ([source](https://github.com/Tencent/APIJSON/blob/master/README-Chinese.md))

### Web Development

- [Schema-Driven API Generators](https://awesome-repositories.com/f/web-development/schema-driven-api-generators.md) — Automatically transforms relational database schemas into functional HTTP endpoints for CRUD operations and data retrieval.
- [Client-Side Response Shaping](https://awesome-repositories.com/f/web-development/backend-development/request-response-handling/request-and-response-transformers/client-side-response-shaping.md) — Allows clients to define the exact data structure and fields required in a single request. ([source](https://github.com/Tencent/APIJSON/blob/master/README-Chinese.md))
- [Client-Defined Response Shaping](https://awesome-repositories.com/f/web-development/client-defined-response-shaping.md) — Allows clients to define custom JSON response structures and field aliases directly within the request to reduce payload size.
- [Type-Safe Client Generators](https://awesome-repositories.com/f/web-development/api-client-generators/type-safe-client-generators.md) — Produces type-safe client code from API specifications to ensure consistency between frontend and backend. ([source](http://apijson.cn/api))
- [Request Snippet Generators](https://awesome-repositories.com/f/web-development/api-client-generators/type-safe-client-generators/frontend-client-generators/request-snippet-generators.md) — Generates ready-to-use request snippets for frontend clients and scripts based on defined API queries. ([source](https://cdn.jsdelivr.net/gh/tencent/apijson@master/README.md))
- [API Parameter Validation](https://awesome-repositories.com/f/web-development/api-parameter-validation.md) — Enforces advanced input rules and parameter dependencies to ensure data integrity before processing. ([source](http://apijson.cn/doc/zh/newinterface.html))

### Security & Cryptography

- [Endpoint Controls](https://awesome-repositories.com/f/security-cryptography/api-access-control/endpoint-controls.md) — Allows administrators to control access and enable or disable specific generated API endpoints. ([source](http://apijson.cn/doc/zh))
- [Database Injection Prevention](https://awesome-repositories.com/f/security-cryptography/application-and-system-security/web-security/input-sanitization/database-injection-prevention.md) — Automatically sanitizes and parameterizes inputs to prevent SQL injection attacks on the database layer. ([source](https://github.com/Tencent/APIJSON/blob/master/README-Chinese.md))
- [Database Access Controls](https://awesome-repositories.com/f/security-cryptography/granular-access-controls/database-access-controls.md) — Provides granular permission and role management to secure API endpoints and restrict database access.
- [Row Level Security](https://awesome-repositories.com/f/security-cryptography/identity-access-management/access-control/data-resource-permissions/row-level-security.md) — Implements granular access control by filtering database records based on the authenticated user's assigned permissions.
- [Role-Based Access Controls](https://awesome-repositories.com/f/security-cryptography/role-based-access-controls.md) — Enforces granular security policies at both the table and row level based on assigned user roles. ([source](https://github.com/Tencent/APIJSON/blob/master/README-Chinese.md))
- [Request Validation Middleware](https://awesome-repositories.com/f/security-cryptography/request-validation-middleware.md) — Includes middleware that validates user permissions and sanitizes input for every incoming request. ([source](http://apijson.cn/doc/))

### Software Engineering & Architecture

- [Dynamic Response Shaping](https://awesome-repositories.com/f/software-engineering-architecture/dynamic-response-shaping.md) — Allows the requesting client to specify the exact JSON structure and field aliases returned by the server.
- [Automated API Documentation](https://awesome-repositories.com/f/software-engineering-architecture/automated-api-documentation.md) — Generates technical specifications and living documentation directly from the database schema. ([source](http://apijson.cn/doc/))
- [Remote Function Invocation](https://awesome-repositories.com/f/software-engineering-architecture/remote-function-invocation.md) — Triggers remote functions or stored procedures to handle complex business rules and data transformations. ([source](http://apijson.cn/doc/zh/all.html))

### Testing & Quality Assurance

- [API Endpoint Testing](https://awesome-repositories.com/f/testing-quality-assurance/api-endpoint-testing.md) — Provides tools for sending live HTTP requests to verify server responses against specifications. ([source](http://apijson.cn/api))
- [API Regression Testing](https://awesome-repositories.com/f/testing-quality-assurance/api-regression-testing.md) — Provides automated regression testing by saving request history to verify endpoint behavior. ([source](https://cdn.jsdelivr.net/gh/tencent/apijson@master/README.md))
- [Test Case Organizers](https://awesome-repositories.com/f/testing-quality-assurance/software-testing/test-execution-orchestration/test-case-generators/test-case-organizers.md) — Organizes and manages interface use cases with built-in validation and result summarization. ([source](http://apijson.cn/doc/))