Awesome Open Source
Awesome Open Source

ElectroCRUD 2 GitHub Release Date Open Collective backers and sponsors


ElectroCRUD is Open Source Database CRUD (Create, Read, Update, Delete) Software. No Code Needed — Just in a few clicks, you can create a Database Admin/Dashboard/Whatever. Its Open Source — It's Free.


After a failed search for a basic admin panel that does not involve writing code or installs web-based solutions, I came up with ElectroCRUD idea.

ElectroCRUD v1

The ElectroCRUD v1 was born in 2016. An Electron application that made it possible to create a friendly dashboard with data tables, search, widgets, filter & relations with few clicks without any experience in programming.

ElectroCRUD v2

After a few years of the project being inactive, I decided to bring it to life again. The codebase was built from scratch using Electron+Angular8. The new version contains most of the features of the first version, and new features are added on a weekly basis.

From version 2.7.0 SQLite has been added, currently its very limited support but we working on full support for next version.




  • [x] MySQL Support
  • [x] PostgreSQL Support
  • [x] SQLite Support (limited support, work in progress)
  • [x] SSH Tunnels (Keys & Password)
  • [x] Accounts (represent a database)
    • [x] Add / Edit
    • [x] Test connection (ssh, db)
    • [ ] Export / Import
  • [x] Views (represent a table)
    • [x] Add new view & Edit view configurations
    • [x] Data table with pagination
    • [x] Search
    • [x] Permissions (C,R,U,D)
    • [x] Terminology
    • [x] Selection of columns to display or search by
    • [x] Add new record / Edit record
    • [x] Edit record
    • [x] Connect existing view as sub views
    • [ ] Export data in various formats like: csv, dump
  • [x] Custom SQL Queries
  • [x] Subviews (represent a sub table)
  • [x] Views relations
    • [x] Drill from view to view (subview)
    • [x] Column based tables relation (left join)
  • [x] View widgets (display aggragated data in the view)
    • [x] Add / Edit / Remove widgets
    • [x] Aggregation functions (AVG, SUM, MIN, MAX, COUNT)
    • [ ] Apply filters on widget data
  • [x] View filters (build where clauses to filter the data)
    • [x] Add / Edit / Remove filter in each view
    • [x] One click apply / unapply on view data
    • [x] Simple & friendly interface to build where clauses
  • [ ] Process manager (view running queries)
  • [ ] Export / Import of all user accounts.
  • [x] Themes
  • [x] Log Console


  • [x] MySQL/MariaDB
  • [x] PostgreSQL
  • [x] SQLite (Limited support)
  • [ ] MSSQL
  • [ ] Oracle

Download Binaries GitHub release

Install via Package Managers

Homebrew/brew (Mac OS/X)

brew install --cask electrocrud

Download Sources

ElectroCRUD on GitHub


How to use Review by David Mettler (ver 2.6.1)


Build from source

npm install

With codesign

npm run electron:mac-win-linux

Without codesign

CSC_IDENTITY_AUTO_DISCOVERY=false npm run electron:mac-win-linux

GitHub All Releases GitHub package.json version Analytics

Alternatives To Electrocrud
Select To Compare

Alternative Project Comparisons
Related Awesome Lists
Top Programming Languages

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
Typescript (280,846
Database (92,838
Mysql (31,952
Postgres (24,362
Postgresql (24,362
Sql (22,608
Sqlite (10,164
Sqlite3 (10,164
Edit (7,412
Rdbms (1,072
First Timers Only (35