Adminer
Adminer is a comprehensive database management tool, designed to simplify and streamline your database operations. Written in PHP, it is a lightweight yet powerful tool that supports a wide range of databases including MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others. With Adminer, you can easily connect to a database server using a username and password, select an existing database or create a new one, and manage all aspects of your database including tables, columns, indexes, foreign keys, triggers, views, stored procedures, and functions. It also allows you to execute any SQL command from a text field or a file, and export your database structure, data, views, routines, and databases to SQL or CSV. Adminer prioritizes security, user experience, performance, feature set, and size, making it a reliable and efficient tool for all your database management needs.
Baserow
Baserow is an open-source, no-code database tool that allows you to create your own online database without any technical experience. It is a user-friendly alternative to Airtable, offering the power of a developer right from your browser. Baserow is perfect for organizing your projects, ideas, or business processes, allowing you to structure everything according to your needs. It is a flexible software that can be tailored to your needs, ensuring clear and accessible data for all your team members. With Baserow, you can easily integrate with other software, collaborate in real-time, and enjoy unlimited rows for your data. It is also developer-friendly, allowing for the creation of custom plugins. Baserow offers a free plan for those who want to try it out, as well as premium and advanced plans for users with more advanced needs.
Bytebase
Bytebase is a versatile application designed to streamline database management tasks. It supports a wide range of databases including MySQL, PostgreSQL, Snowflake, Oracle, SQL Server, MongoDB, Redis, Redshift, ClickHouse, TiDB, OceanBase, Google Spanner, and MariaDB. With Bytebase, you can easily configure and manage your database instances, perform SQL reviews, manage data models, roles, and permissions, and handle change workflows in batch mode. The app also offers features for secure data handling, VCS integration, slow query management, and disaster recovery. It comes with an embedded PostgreSQL instance for storing its metadata, but for production setup, it is recommended to store the metadata in an external PostgreSQL database. Bytebase is designed to be deployed easily and quickly, offering a step-by-step quick start guide for users.
Clickhouse
ClickHouse is an open-source database designed for real-time apps and analytics. It is renowned for its speed and resource efficiency, capable of querying billions of rows in mere milliseconds. ClickHouse supports a wide range of data sources, including databases, data warehouses, streams, logs, analytics, data lake formats, and local files. It is built on a column-oriented database structure, which is ideally suited to Online Analytical Processing (OLAP) scenarios, making it significantly faster in processing most queries. ClickHouse utilizes all available system resources to their full potential to process each analytical query as swiftly as possible. It can be deployed in any environment, whether on your machine or in the cloud, and offers the ability to run fast queries on local files without a server. ClickHouse is trusted by developers working with data at scale, including major companies like Disney+ and Uber.
Directus
Directus is a modern, open-source data platform that instantly transforms any SQL database into an API and a beautiful no-code app. It is designed to work with any SQL database, allowing you to maintain complete control over your new or existing database without the need for migration to a proprietary data model. The Directus API layers on top of your database, providing both REST and GraphQL APIs for your data. The Directus App enables your entire team to safely and intuitively browse, manage, and visualize data. It is a flexible platform that can be used as a Backend-as-a-Service, a Headless CMS, an Internal Tool Builder, and for Data Management & Analytics. With Directus, you can connect external digital experiences, design APIs, control data flows, build internal tools, and much more.
Docker Registry
Docker Registry 2.0 is a powerful application designed to store and distribute Docker images. This app is an implementation of the Docker Registry HTTP API V2, compatible with Docker 1.6 and later versions. It provides a secure and scalable base for building a large scale registry solution or running a simple private registry. Docker Registry 2.0 is a core library for many registry operators including Docker Hub, GitHub Container Registry, GitLab Container Registry, and DigitalOcean Container Registry. It is also used by the CNCF Harbor Project and VMware Harbor Registry. The app allows users to efficiently store, manage, package, and exchange content, providing a professional grade and extensible content distribution system.
Hasura
Hasura is a powerful Data API Platform that automates the process of building, securing, optimizing, and deploying GraphQL and REST APIs. It eliminates the need for manual API creation, enabling developers to generate APIs effortlessly by connecting to existing databases. This results in rapid, scalable application development. Hasura is compatible with a variety of popular databases, including PostgreSQL, MySQL, and MongoDB, allowing you to build GraphQL APIs on top of your existing databases. It also provides comprehensive tools to secure APIs beyond authentication and authorization. With Hasura, you can accelerate the development of new applications or add new features to an existing application in days instead of weeks. It also helps in fast-tracking cloud migration, frontend and backend modernization, and application re-architecture projects by automating 80% of your API development work.
Mongo Express
mongo-express is a web-based MongoDB admin interface designed with Node.js, Express, and Bootstrap3. It allows you to connect to multiple databases, view, add, delete databases, and manage collections. You can also view, add, update, and delete documents within these collections. The app supports previewing audio, video, and image assets inline in the collection view. Large or nested objects are collapsible for easy overview, and big document properties are loaded on-demand to keep the collection view fast. The app also supports GridFS, enabling you to add, get, and delete incredibly large files. It uses BSON data types in documents and is mobile responsive, thanks to Bootstrap 3. The app also supports connection and authentication to individual databases, as well as admin authentication to view all databases. It includes features for database blacklist/whitelist, custom CA, and CA validation disabling, and supports replica sets.
MySQL Backup
The mysql-backup-s3 app is a powerful tool designed to backup your MySQL databases to your AWS S3 bucket. It supports periodic backups, allowing you to schedule backup times in cron format, ensuring your data is always safe and up-to-date. The app also supports multi-files, meaning you can have one file per database if you choose to. The app requires your AWS access key, AWS secret key, and AWS S3 bucket path. It also requires your MySQL host, user, and password. You can customize the path prefix in your bucket, the AWS S3 bucket region, and the AWS Endpoint URL. The app also allows you to add extra mysqldump options without overriding the default ones. With the mysql-backup-s3 app, you can ensure your MySQL databases are always backed up and secure in your AWS S3 bucket.
NocoDB
NocoDB is an innovative open-source platform that transforms any database into a smart spreadsheet. It's a powerful alternative to Airtable, designed to be flexible and user-friendly. With NocoDB, you can create unlimited grid views, gallery views, and form views from your own data. It offers ultra-ease in searching, sorting, and filtering columns and rows. You can invite your team with fine-grained access control, share views publicly or with password protection. NocoDB also allows you to build automations with your favourite apps like Microsoft Teams, Slack, Discord, Whatsapp, Twilio, Email & SMS. It provides instant REST APIs with Swagger. NocoDB is trusted by over 2000 organizations worldwide and is the fastest growing open source project. It's free and self-hostable, offering endless solutions for your business workflows.
pgvector
pgvector is an open-source app designed to facilitate vector similarity search for Postgres. It allows you to store all your application data in one place, supporting both exact and approximate nearest neighbor search. The app is capable of handling L2 distance, inner product, and cosine distance, making it versatile for various data analysis needs. It is compatible with any language that has a Postgres client. The app also boasts of ACID compliance, point-in-time recovery, JOINs, and all the other great features of Postgres. With pgvector, you can create a new table with a vector column or add a vector column to an existing table, insert vectors, upsert vectors, update vectors, and delete vectors. It also allows you to get the nearest neighbors to a vector or a row, and get rows within a certain distance. The app also supports indexing for improved search performance. It is a powerful tool for managing and analyzing your data in a Postgres environment.
pgweb
Pgweb is a simple, web-based, cross-platform PostgreSQL database explorer. It is designed to work seamlessly on Mac, Linux, and Windows machines. The app is distributed as a single binary with zero dependencies, making it incredibly easy to use. It supports PostgreSQL 9.1 and later versions, and allows for multiple database sessions. With Pgweb, you can execute and analyze custom SQL queries, export table and query data to CSV/JSON/XML, and keep track of your query history. The app also supports native SSH tunnels and server bookmarks for easy navigation.
phpMyAdmin
phpMyAdmin is a free software tool designed to manage MySQL over the web. This powerful tool supports a broad spectrum of operations on MySQL and MariaDB. It allows you to perform frequently used operations such as managing databases, tables, columns, relations, indexes, users, permissions, and more through its user-friendly interface. Additionally, it provides the flexibility to directly execute any SQL statement. phpMyAdmin also features an intuitive web interface and supports most MySQL features. You can browse and drop databases, tables, views, fields, and indexes; create, copy, drop, rename, and alter databases, tables, fields, and indexes; manage MySQL user accounts and privileges; and much more. It also allows you to import data from CSV and SQL, export data to various formats, administer multiple servers, create graphics of your database layout in various formats, and create complex queries using Query-by-example (QBE).
PocketBase
PocketBase is a powerful backend solution for your next SaaS or Mobile app. It is designed to be ready to use out of the box, providing a realtime database, user authentication, file storage, and an admin dashboard all in one file. The realtime database is embedded and performant, featuring a schema builder, data validations, realtime subscriptions, and an easy-to-use REST API. The authentication feature allows you to manage your app users and handle email/password and OAuth2 sign ups from various platforms like Google, Facebook, GitHub, GitLab without any hassle. The file storage feature allows you to store files locally or in an S3 storage, attach media to your database records, and generate thumbnails on the fly. PocketBase is extendable and can be used as a standalone app or as a Go framework, which you can extend via hooks to create your own custom portable backend. It also provides official client SDKs for seamless integration.
Postgres Backup
The postgres-backup-s3 app is a powerful tool designed to backup your PostgreSQL databases to Amazon S3. It supports periodic backups, allowing you to schedule automatic backups at your convenience. This ensures that your data is always safe and can be restored whenever needed. The app also offers the option to backup all available databases at once, creating a single archive with a timestamp for easy identification. For added security, the app provides an encryption feature. By setting an encryption password, your backup can be encrypted and only decrypted with the correct password. This app is perfect for those who want to ensure their PostgreSQL databases are securely backed up in a reliable and efficient manner.
Qdrant
Qdrant is a powerful vector database and vector similarity search engine designed to power the next generation of AI applications. It deploys as an API service, providing search for the nearest high-dimensional vectors. This allows embeddings or neural network encoders to be turned into full-fledged applications for matching, searching, recommending, and much more. Qdrant supports a large variety of data types and query conditions, including string matching, numerical ranges, geo-locations, and more. It is cloud-native and scales horizontally, ensuring efficient utilization of resources. With Qdrant, you can build and deploy semantic neural search on your data in minutes, understand user behavior in real time, and find similar images or detect duplicates with ease.
Weaviate
Weaviate is an open-source vector database that allows you to store and retrieve data objects based on their semantic properties by indexing them with vectors. It can be used stand-alone or with a variety of modules that can do the vectorization for you and extend the core capabilities. Weaviate provides a lightning-fast pure vector similarity search over raw vectors or data objects, even with filters. It combines keyword-based search with vector search techniques for state-of-the-art results. You can also use any generative model in combination with your data, for example to do Q&A over your dataset. Weaviate's next-gen vector database can power a wide range of innovative apps.