Crow's Foot

Crow's Foot is a browser-based ER diagram editor for PostgreSQL schemas. It lets you sketch tables and relations visually, import PostgreSQL DDL, and export the result as SQL, JSON, or PNG.

The current application UI is primarily in Russian.

Features

• Visual table editor with Crow's Foot relation edges.
• PostgreSQL-oriented column metadata: primary keys, foreign keys, uniqueness, nullability, defaults, and comments.
• DDL import for common CREATE TABLE and ALTER TABLE ... ADD CONSTRAINT patterns.
• Live PostgreSQL DDL generation.
• JSON export/import for diagrams.
• PNG export for sharing diagrams.
• Browser-local save/load through localStorage.
• View mode and Martin notation presentation mode.

Tech Stack

• React
• TypeScript
• Vite
• @xyflow/react
• Zustand
• Bun

Requirements

• Bun 1.3.14 or newer compatible with the lockfile.

Development

Install dependencies:

bun install

Start the development server:

bun run dev

Build for production:

bun run build

Preview the production build:

bun run preview

License

MIT. See LICENSE.