All Projects → garrylachman → Electrocrud

garrylachman / Electrocrud

Licence: mit
Database CRUD Application Built on Electron | MySQL, Postgres, SQLite

Programming Languages

32286 projects

Projects that are alternatives of or similar to Electrocrud

SQL builder and query library for golang
Stars: ✭ 984 (-22.34%)
Mutual labels:  sql, database, mysql, postgresql, sqlite, postgres
Vscode Sqltools
Database management for VSCode
Stars: ✭ 741 (-41.52%)
Mutual labels:  sql, mysql, postgresql, sqlite, postgres, sqlite3
Free universal database tool and SQL client
Stars: ✭ 23,752 (+1774.66%)
Mutual labels:  sql, database, mysql, postgresql, sqlite
A Clojure(script) SQL library for building APIs: Datomic® (GraphQL-ish) pull syntax, data driven configuration, dynamic filtering with relations in mind
Stars: ✭ 384 (-69.69%)
Mutual labels:  sql, mysql, postgresql, sqlite, sqlite3
Ebean ORM
Stars: ✭ 1,172 (-7.5%)
Mutual labels:  sql, database, mysql, sqlite, postgres
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Stars: ✭ 2,832 (+123.52%)
Mutual labels:  sql, database, mysql, postgresql, sqlite
Type safe SQL builder with code generation and automatic query result data mapping
Stars: ✭ 373 (-70.56%)
Mutual labels:  sql, database, mysql, postgresql, postgres
Generate a Go ORM tailored to your database schema.
Stars: ✭ 4,497 (+254.93%)
Mutual labels:  database, mysql, postgresql, postgres, sqlite3
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (-86.66%)
Mutual labels:  sql, mysql, postgresql, sqlite, sqlite3
The database toolkit for go
Stars: ✭ 524 (-58.64%)
Mutual labels:  sql, database, mysql, postgresql, sqlite3
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Stars: ✭ 498 (-60.69%)
Mutual labels:  database, mysql, postgresql, sqlite, sqlite3
Go Sqlbuilder
A flexible and powerful SQL string builder library plus a zero-config ORM.
Stars: ✭ 539 (-57.46%)
Mutual labels:  sql, database, mysql, postgresql, sqlite
Database migrations. CLI and Golang library.
Stars: ✭ 2,315 (+82.72%)
Mutual labels:  sql, database, mysql, sqlite, postgres
Advanced, Powerful and easy to use ORM for Qt
Stars: ✭ 181 (-85.71%)
Mutual labels:  sql, database, mysql, postgresql, sqlite
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL.
Stars: ✭ 5,039 (+297.71%)
Mutual labels:  sql, mysql, postgresql, sqlite, postgres
Linq to database provider.
Stars: ✭ 2,211 (+74.51%)
Mutual labels:  sql, database, mysql, postgresql, sqlite
A database migration tool. Supports SQL migrations and Go functions.
Stars: ✭ 2,112 (+66.69%)
Mutual labels:  sql, database, mysql, sqlite, postgres
Automatically identify anti-patterns in SQL queries
Stars: ✭ 2,062 (+62.75%)
Mutual labels:  sql, database, mysql, postgresql, sqlite3
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (-62.35%)
Mutual labels:  sql, database, mysql, postgresql, sqlite
Beekeeper Studio
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Stars: ✭ 8,053 (+535.6%)
Mutual labels:  sql, database, mysql, postgresql, sqlite

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

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].