#44th of 4 in Backends and databases

apijson

Java ORM that exposes CRUD APIs over JSON requests without per-endpoint code

Live demo ↗ Documentation ↗ Repository on GitHub ↗

Stars: 18.4k
License: custom license
Last commit: Oct 2026
Last release: Oct 2026
Language: Java

Stars, last 29 weeks+135

18,254 on 24 Mar 202618,389 on 13 Oct 2026

From GitHub's daily star counts.

Checked 14 Oct 2026 on GitHub.

Overview

APIJSON is a Java library and JSON-based protocol. Clients send a JSON describing the tables and fields they want, and the server maps it to SQL and returns JSON in the same shape, so backend developers write no per-endpoint CRUD code. It covers reads, writes, fuzzy search and remote function calls, and ships with API docs and test tooling (APIAuto).

Who it is for: Java backend developers who want codeless CRUD APIs over SQL or NoSQL databases

Strengths

One JSON request can query several related tables, replacing multiple endpoint calls
Many data sources listed: MySQL, PostgreSQL, Oracle, SQL Server, ClickHouse, Redis, Kafka, Elasticsearch
Added via Maven or Gradle through JitPack; works with Spring, SpringBoot, JFinal, Nutz
Community ports listed for Go, C#, PHP, Node.js, Python and Rust

Weaknesses

Java-centric; non-Java ports are separate third-party repositories with unknown maturity
License is reported as NOASSERTION, so terms need checking before use
README gives no setup steps for a standalone server; points to a separate demo repo
Not AI-specific; it is a general ORM and API protocol

What it needs

no GPU
Needs Java 1.8+, A supported database (e.g. MySQL 5.7+, PostgreSQL 9.5+)

Head to head

Also in Backends and databases

See all 4

Also in Backends and databases
Rank	Project	Score
1	supabasePostgres backend with auth, storage, realtime and edge functions111.5k starsApache-2.0	73 out of 100
2	parse-serverNode.js backend with REST and GraphQL APIs on MongoDB or PostgreSQL21.4k starsApache-2.0	66 out of 100
3	graphql-engineGraphQL API layer over Postgres, MongoDB, ClickHouse and SQL Server32.1k starsApache-2.0	65 out of 100

How to choose

Check what you get self-hosted versus only in the managed cloud.
See how it handles auth, row-level security and file storage.
Look at the client SDKs for your stack.

Health

Releases: 5 in the last 12 monthsLast one 9 days ago
Top contributor: 86% of commits122 of 142 in the last 12 months
Security advisories: NoneOn GitHub, in the last 12 months
OpenSSF Scorecard: Not checked

Read from GitHub, deps.dev and OpenSSF on 14 Oct 2026. Bots and coding-agent accounts are left out of the commit counts. Not part of the score: how we check.

License in plain words

custom license Custom terms

Use it at work: Check
Change it and rebrand it: Check
Sell it or host it for others: Check

Your part: GitHub could not match these terms to a standard license. Read the license before you use it at work, rebrand it or host it for others.

A plain summary, not legal advice. Read the license on GitHub ↗ (opens in a new tab)

#4 of 4 in Backends and databases on Archestack, as of 14 Oct 2026.

In your README

The badge updates twice a day.

[![Archestack](https://archestack.com/badge/apijson/apijson.svg)](https://archestack.com/best-of-vibe-coding/projects/apijson/)

How badges work

On your site or blog

A card with the rank, score and signals, in light or dark to match the reader.

<iframe src="https://archestack.com/embed/best-of-vibe-coding/apijson/" title="apijson on Archestack" width="400" height="270" style="border:0;max-width:100%" loading="lazy"></iframe>

Preview the card

Best of Vibe Coding on GitHub

Each review comes from the project's README and facts we check on GitHub. The fix form opens with apijson filled in.