Grocery Restable

Your database, as an API

// app/Config/GroceryRestable.php (CodeIgniter 4)
public function define(\GroceryRestable\GroceryRestable $api): void
{
    $api->resource('employees')
        ->setRelation('officeCode', 'offices', '{city} ({country})')
        ->requiredFields('lastName', 'email')
        ->setRules('email', 'required|valid_email')
        ->setFieldUpload('photo', 'employees', 'jpg|png');
}

curl "https://example.com/api/employees?select=lastName,offices(city)&officeCode=eq.4&order=lastName.desc" \
  -H "apikey: <YOUR_KEY>"

What you get

Instant REST endpoints	List, read, create (single, bulk, upsert), update, delete, clone and CSV export for every table and view.
PostgREST-style queries	select with embedded relations, filters (eq, gt, in, ilike, is, not. …), or / and groups, ordering, paging and exact counts.
Relations like Grocery CRUD	belongs_to, many_to_many (with writes) and has_many — in code, in the GUI, or detected from foreign keys.
Three ways to define the API	Fluent PHP code (Grocery CRUD compatible), the admin GUI (stored in SQLite), or automatic exposure of every table.
Uploads & storage	Field uploads and Supabase-style storage buckets with extension allow-lists, MIME sniffing and traversal protection.
Security built in	API keys (anon / service_role), JWT, per-role permissions, row-level security, CORS, encrypted secrets.
Admin GUI	phpMyAdmin-style interface: setup wizard, table browser, resource and relation editors, API keys, storage, docs, console.
OpenAPI 3.1	A live openapi.json for Swagger UI, Postman and code generators, plus _schema metadata for form builders.

Choose your setup

• CodeIgniter 4 — composer require, and routes, services and spark commands are discovered automatically.
• No framework — a single front controller on plain PHP with PDO or MySQLi.
• Then follow the Getting started tutorial, or jump to the REST API reference.

---

Grocery Restable is MIT licensed. Inspired by Grocery CRUD. Not affiliated with or endorsed by Grocery CRUD / John Skoumbourdis.