P
pgkiln/pgkiln
Low-code application builder for PostgreSQL: build data-driven web apps in SQL
SECURITY.md ✓
在 GitHub 查看 ↗链接已于 2026-11-12 核查 · HTTP 200 · 打开的是厂商自己的官网
安装与配置
客户端配置（取自该仓库的安装命令）
{
"mcpServers": {
"pgkiln-pgkiln": {
"command": "npx",
"args": ["playwright"]
}
}
}解析自我们于 2026-10-26 抓取的该仓库 README；我们未执行过。
command/args 来自仓库写明的安装命令；不确定时请以该项目 README 为准。
VS Code（.vscode/mcp.json —— 键名是 servers）
{
"servers": {
"pgkiln-pgkiln": {
"command": "npx",
"args": ["playwright"]
}
}
}VS Code 顶层键是 <code>servers</code>，其余与上面那份相同。
Claude Code（命令行）
claude mcp add --transport stdio pgkiln-pgkiln -- npx playwright
Claude Code 不收 JSON 文件，用这条命令直接加。
配置项的键名以你的客户端为准：客户端与 CLI
- ★ 数取值
- 2 ★ · pgkiln/pgkiln · 取自 GitHub 搜索 API · （2026-11-13 20:00:50 核对）
- 来源明细
- 从该仓库的 GitHub 页面直接读取 · 条目类型：开源项目
- 收录与活跃
- 收录于 2026-10-22 · 最近见到 2026-11-14 · 共见到 27 次 · 被 2 个来源列出
- 评分构成
- 综合分 203 · 2 ★ · 2 个来源 · repo
- 安装
npx playwright
常见问题（答案都来自我们的记录）
怎么安装？
该仓库给出的安装命令是
npx playwright。我们的记录里它是仓库自己提供的；不保证在你的客户端上直接可用。它适合谁 / 用来做什么？
我们把它归在这些标签下: 开源项目。标签来自条目自身，不是我们强加的分类。
谁维护它、还在更新吗？
仓库
pgkiln/pgkiln；我们收录于 2026-10-22；最近见到 2026-11-14。这里没有"官方认证"或"质量评级"——我们只记录来源与时间。# 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
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
收录徽章（可选）
想把收录标记放进 README 就复制这行，可选，不影响收录。
[](https://anclum.com/zh/s/pgkiln-pgkiln/)
- 来源
- github · https://github.com/pgkiln/pgkiln
- 按领域浏览
- 开源项目
- Traction
- 2 ★
- 收录来源
- 2 个独立来源
- 收录于
- 今天
- 安全策略
- 该仓库根目录有
SECURITY.md（我们只核文件存在，未核内容）
同类推荐
所属领域与标签
每个标签都能点进去看同类的全部条目。数字是当前库里的真实条数。