pgkiln/pgkiln

Low-code application builder for PostgreSQL: build data-driven web apps in SQL

Before you install: no copy-paste command · license Apache-2.0 · link reachable

First step: npm install

SECURITY.md ✓

View on GitHub ↗Link checked 2026-11-12 · HTTP 200 · opens the vendor's own site

Install & config

Client config (built from the install command this repo gives)

{
  "mcpServers": {
    "pgkiln-pgkiln": {
      "command": "npx",
      "args": ["playwright"]
    }
  }
}

Parsed from the README we fetched on 2026-10-26; we have not executed it.

command/args come from the install command the repository states. When it is ambiguous, the project README wins.

VS Code (.vscode/mcp.json - the key is servers)

{
  "servers": {
    "pgkiln-pgkiln": {
      "command": "npx",
      "args": ["playwright"]
    }
  }
}

Same server, but VS Code keeps it under <code>servers</code>.

Claude Code (command line)

claude mcp add --transport stdio pgkiln-pgkiln -- npx playwright

Claude Code does not read a config file; add the server with this command.

Key names differ by client: Clients & CLI

Star count: 2 ★ · pgkiln/pgkiln · read from the GitHub search API · (checked 2026-11-13 20:00:50)
Source: read directly from its GitHub page · type: open-source project
Harvest history: first seen 2026-10-22 · last seen 2026-11-14 · seen 27× · listed by 2 sources
Score: score 203 · 2 ★ · 2 sources · repo
Install: npx playwright

FAQ (answers come from our records)

How do I install it?

The repository provides this install command: npx playwright. It comes from the repository itself; we cannot guarantee it runs as-is in your client.

Who is it for?

We filed it under these tags: 开源项目. The tags come from the entry itself, not a taxonomy we imposed.

Who maintains it?

repository pgkiln/pgkiln；first catalogued 2026-10-22；last seen 2026-11-14。There is no official certification or quality rating here — we record sources and dates only.

# pgkiln

以下摘录自该仓库的 README（片段） · 在 GitHub 读完整 README →

Website · Documentation ·
Tutorial · Coming from Oracle APEX ·
Roadmap
A low-code, SQL-driven application builder for PostgreSQL, modeled on
Oracle APEX. Applications are data: pages, regions, items, buttons,
dynamic actions, validations and processes are rows in the meta schema. A
runtime turns those rows into web pages, and the builder is an editor for
them.
> pgkiln is an independent open source project and is not affiliated with Oracle. Oracle and APEX are trademarks of Oracle.
## Screenshots
Everything below is the HR example application (npm run example:hr) and the builder. The
screenshots are made by npm run screenshots.
| Dashboard: metric cards and charts, all of it SQL | Interactive report: search, filters, sort, download |
| Smart filters and faceted search | Map and cards regions on the same table |
| Charts, in dark mode | Calendar of leave requests |
| App Builder home | SQL Workshop: object browser with RLS and grants |
Responsive on phones and tablets, and installable as a Progressive Web App
## Quick start
With Docker (no Node.js needed):
bash
mkdir pgkiln && cd pgkiln
curl -fsSLO https://raw.githubusercontent.com/pgkiln/pgkiln/main/deploy/compose.yaml
curl -fsSL -o .env https://raw.githubusercontent.com/pgkiln/pgkiln/main/deploy/.env.example # fill in the four secrets
docker compose up -d # http://127.0.0.1:3100/builder (admin / the password from .env)
Or from the source, for developing:
bash
npm install
cp .env.example .env
npm run setup # Postgres 17 on localhost:5434 + the pgkiln schema (migrations)
npm run dev # http://127.0.0.1:3100/builder (admin / admin)
Then build an application on your own tables: Create application in the builder generates
report and form pages from a table, and everything else (regions, items, processes, security,
translations, documents, approvals) is added in the page designer and Shared Components. The
tutorial walks through one.
### The example application
pgkiln itself contains no application. The repository ships an example built on it, HR
(examples/hr/): employees and departments, leave requests with approvals, a dashboard, a REST API,
translations, documents, automations and row level security, all of it ordinary pgkiln metadata
and PostgreSQL code, the way you would build your own.
bash
npm run example:hr # http://127.0.0.1:3100/a/hr
Users (password = username): king is admin and manager (the president), blake and jones are
managers, allen and scott are employees, and demo is an admin who is not an employee. Sign
in as different users to see authorization schemes and row level security at work.
### Developing pgkiln
bash
npm test # unit + security regression tests (installs the HR example as their fixture)
npm run test:e2e # browser tests on phone/tablet/desktop (npx playwright install chromium first)
npm run db:reset recreates the database (pgkiln only). Schema changes go in a new
db/migrations/NNN.sql file; npm run db:migrate applies pending ones.
## Working with AI coding agents
pgkiln ships an MCP server (pgkiln mcp), so Claude Code, Cursor and other agents can find an
application, read and explain its pages, look at the tables and RLS policies behind them, search

Listed badge (optional)

Copy this line into the README if you want the listing mark. Optional, and it does not affect being listed.

[![Listed on Anclum](https://anclum.com/badge/listed.svg)](https://anclum.com/en/s/pgkiln-pgkiln/)

Source: github · https://github.com/pgkiln/pgkiln
Browse by field: Open source
Traction: 2 ★
Listed by: 2 independent sources
added: today
Security policy: the repository has SECURITY.md at its root (we checked that the file exists, not what it says)

More like this

ComplyEaze/bridgeOpen-source project melodic-software/claude-code-pluginsOpen-source project relaticle/relaticleOpen-source project

All 1,671 →

Filed under

Open source1,671 entries Open-source repo2,514 From GitHub2,437

Every tag opens the full list for that filter. Counts are the live catalogue figures.

Browse all fields →

← Back to index