database
If you are looking for a simple, intuitive, and free database schema editor? Then we highly recommend drawDB, a lightweight, open-source ER diagram tool that runs in your browser and helps you visualize, design, and generate SQL scripts for your database, all without signing up or installing anything. Whether you&
Open-source
Meet Manifest: The One-File Backend That Feels Like Magic, free and open-source!
Artificial Intelligence
As someone with a background in medicine and software development, I've always appreciated tools that simplify complex tasks. Converting natural language into SQL queries—what we now call prompt to SQL—is one of those innovations that bridges the gap between technical expertise and usability. Whether you'
database
A database management and administration system is a tool that helps you work with databases. Databases are where all the important data for your applications, websites, or systems is stored—like user information, transactions, or content. 14 Open-source Web-based SQL Database ManagersSQL stands for Structured Query Language, and it is
sql
HeidiSQL is a powerful yet user-friendly graphical interface designed to make managing databases a breeze. Whether you're working with MariaDB, MySQL, Microsoft SQL Server, PostgreSQL, SQLite, Interbase, or Firebird, HeidiSQL has got you covered. It lets you explore and edit your data, build and modify tables, views, procedures,
mysql
Are you a data pro juggling SQL Server or Azure SQL? Meet Azure Data Studio (ADS), Microsoft’s free and open-source tool that’s designed to simplify your life. This isn’t just another SQL editor; it’s a powerhouse packed with features to help you write queries, manage databases,
database
Unlocking the Power of Databases Through Natural Language
database
Ever wanted to peek under the hood of a database? That's exactly what students at Carnegie Mellon University (CMU) are doing with BusTub, a hands-on database project that's caught fire beyond the classroom. What's BusTub? It's a stripped-down database system where students
database
DbGate is free and open-source fast and easy to use database manager. It works seamlessly with MySQL, PostgreSQL, SQL Server, and several other database engines. DbGate is getting regular update and it is an ideal solution for database admins, web developers, devOps, and of course data engineers. 14 Open-source Web-based
Open-source
Osquery is a free open-source tool for endpoint monitoring and system instrumentation, initially developed by Facebook and now maintained by the open-source community. It is totally compatible with Linux, macOS, and Windows, Osquery represents OS data—like hardware configuration, file integrity, processes, and network connections—as SQL tables. Osquery users
database
gobang is a free and open-source app that allow developers to manage databases easily from the command-line with a TUI interface. Features * Cross-platform support (macOS, Windows, Linux) * Lighting Fast Speed * Multiple Database support (MySQL, PostgreSQL, SQLite) * Intuitive keyboard only control * Simple configuration Although, it is a polished project, it does
Artificial Intelligence (AI)
Hey there! Ever wished you could just chat with your database like you're texting a friend? Well, that's exactly what AI chat with databases lets you do! Let's dive into how this amazing technology is revolutionizing the way businesses handle their data. What'
database
What is an SQL Client? An SQL client is a software tool that allows users to connect to and interact with a database server using SQL (Structured Query Language). It provides an interface to execute SQL queries, manage database structures, and perform administrative tasks such as backups, updates, and migrations.
database
In today's data-driven world, efficient database management is crucial for businesses, developers, and data analysts alike. Whether you're a seasoned database administrator or a developer just starting out, having the right tools to interact with your SQL databases can significantly impact your productivity and efficiency. SQL
Business Intelligence
Rill is a tool for effortlessly transforming data sets into powerful, opinionated dashboards using SQL. BI-as-code.
data science
Evidence is an open-source, code-based alternative to drag-and-drop business intelligence tools. It is a lightweight framework for building data apps. It's open source and free to get started. Evidence can be easily self-hosted at Netlify, Vercel or even your own server. Generate a Feature-rich website Evidence generates a
Tutorials
SQL (Structured Query Language) is the standard language for managing and manipulating relational databases. It provides various types of commands that allow users to define, manipulate, control, and query data. These commands are categorized into five main types: * Data Definition Language (DDL) * Data Manipulation Language (DML) * Data Control Language (DCL)
Self-hosted
Atlas Hub is a robust task scheduling tool designed to streamline the process of extracting data from various sources and depositing it into desired destinations, such as SQL servers or SFTP servers. It offers extensive capabilities, ensuring seamless data management and automation. Features * Run .bat files on windows servers over
database
A single file database is a database that stores all its data within a single file on the file-system. This design simplifies management, distribution, and deployment. Examples include SQLite and Microsoft Access. These databases are suitable for lightweight applications, mobile apps, and embedded systems where simplicity and ease of use
sqlite
In the ever-evolving world of database technology, finding tools that fit your specific project requirements can be challenging. Two emerging alternatives that are garnering attention are Turso.tech and LibSQL. Here’s why these platforms might be the perfect fit for your next project. What is Turso.tech? Turso.tech
Next.js
As we develop our primary apps using Next.js, we wrote several articles and tutorials about it. Now, it's time to update the collection of the best open-source Next.js 14 starters and boilerplates that can save startups, agencies, and developers a lot of time and money. But
data science
Welcome to our article about the best open-source self-hosted tools for data scientist and engineers. In this fascinating world of data, having the right tools at your disposal is crucial. From data cleaning to visualization, these open-source tools can make your life easier and enhance your workflow. 10 Reasons Why
data science
Apache Superset stands as a premier open-source data exploration and visualization platform, ingeniously designed to facilitate the creation of dynamic, insightful dashboards. It is a must-have tool for data scientists, data engineers, teams and business intelligence experts. Built for Data Exploration It effortlessly empowers users to navigate data from diverse
programming
SQL Query Builders and SQL Generators are incredibly useful tools for developers, especially when dealing with heavy SQL applications. They help construct, manipulate, and manage SQL queries efficiently and effectively. A SQL Query Builder is a tool that aids developers in creating SQL queries. It provides a convenient, often graphical