Open-source data modeling tool for relational database development
Top 93.9% on sourcepulse
dbSpy is an open-source data modeling tool designed for relational database development, offering visualization, modification, and building capabilities. It targets developers and users who need to interact with and design database schemas, providing a visual interface to streamline these processes.
How It Works
dbSpy utilizes a React frontend with a Zustand state management solution for its UI. It supports connecting to existing databases (PostgreSQL, MySQL, Microsoft SQL, Oracle SQL) or uploading SQL files to generate Entity Relationship Diagrams (ERDs). Users can also build databases from scratch on a visual canvas. The tool allows for schema and data modification directly through the UI, generating SQL queries to reflect changes in the database. It also features a query generator and a new query page for running SQL against PostgreSQL or MySQL.
Quick Start & Requirements
npm install
, npm run seed
(to populate MySQL), npm run dev
(to run)..env
file) for database connections and OAuth.Highlighted Details
Maintenance & Community
The project lists numerous contributors and is part of the OSLabs Beta program. PRs are welcome.
Licensing & Compatibility
MIT License. Compatible with commercial use and closed-source linking.
Limitations & Caveats
Oracle SQL connections require a separate OCI download. The project requires a local MySQL database for backend operations and specific environment variable configurations for development.
3 months ago
Inactive