LibreOffice - Base
LibreOffice Base is a free and open source database management application. It is part of the LibreOffice suite and allows users to create, manage, and query databases. Base provides forms, reports, and SQL views for manipulating data.
open-source
database
forms
reports
sql
LibreOffice Base: Free Database Management
A free and open source database management application allowing users to create, manage, and query databases with features like forms, reports, and SQL views.
What is LibreOffice - Base?
LibreOffice Base is a free and open source database management application included as part of the LibreOffice software suite. It provides tools for creating, accessing, and managing SQL databases without the need for any additional database software.
Some of the key features of LibreOffice Base include:
- Graphical database design tools for creating tables, queries, forms, and reports
- Support for standard database engines like MySQL, MariaDB, PostgreSQL, and more
- Multi-table queries and joins
- Custom forms for data entry and editing
- Report creation with filtering and grouping options
- Master-detail linking between tables and forms
- Import and export in multiple formats like ODF, CSV, and SQL
As with all LibreOffice applications, Base is completely free and open source software. It runs on Windows, Linux, and macOS. The database creator allows novice users to get started quickly while still providing more advanced functionality for experienced database developers. Connectivity to external database servers provides scalability when required.
Overall, LibreOffice Base provides a convenient way for individual users and small businesses to create, manage, and organize relational databases without investing in complex proprietary database solutions.
LibreOffice - Base Features
Features
- Relational database management
- Supports many database formats like MySQL, PostgreSQL, Microsoft Access, etc
- Form designer for creating data entry forms
- Report builder for data reports and analysis
- Visual database design tools
- SQL view for advanced queries
- Data import and export
- Database security management
Pricing
- Free
- Open Source
Pros
Free and open source
Cross-platform availability
Tight integration with other LibreOffice components
User-friendly interface
Powerful form and report builders
Supports many database formats
Cons
Limited advanced/enterprise features compared to paid options
Smaller user community than leading databases
Not as feature rich as Microsoft Access
Official Links
The Best LibreOffice - Base Alternatives
Top Office & Productivity and Database Management and other similar apps like LibreOffice - Base
Here are some alternatives to LibreOffice - Base:
Suggest an alternative ❐
DBeaver
DBeaver is a free, open source universal database tool for developers, database administrators, analysts, and all people who need to work with databases. It supports all major databases including MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.Some key features of DBeaver include:Powerful SQL...
NocoDB
NocoDB is an open-source alternative to Airtable that allows users to create databases and tables without needing coding knowledge. It has an intuitive, spreadsheet-style interface that makes it easy for anyone to set up a database in minutes.Some key features of NocoDB include:Creating tables with different column types like text,...
Baserow
Baserow is an open source no-code database and Airtable alternative launched in 2018. Like Airtable, Baserow allows anyone to set up an online database and create applications on top of it without needing to know how to code.Some key features of Baserow include:Intuitive drag-and-drop interface to easily build databases and...
Bento
Bento is an easy-to-use personal database application designed for managing small collections of data on Mac and iOS devices. Developed by Filemaker, Bento provides an intuitive interface that allows users to quickly create databases, tables, forms, reports and charts without any programming or database experience.Some key features of Bento include:Drag-and-drop...
Memento
Memento is an open-source personal database application developed by Mobisystems. It is designed to help users organize information and be more productive by providing a flexible system for capturing, storing, and accessing data.One of the key features of Memento is the ability to create custom databases tailored to the user's...
Oracle APEX
Oracle APEX (Application Express) is a low-code development platform that makes it fast and easy to build scalable, secure enterprise apps. With Oracle APEX, developers can quickly develop and deploy compelling apps that solve real problems and provide immediate value. It uses a declarative interface and wizards to generate full-stack...
Ninox
Ninox is a no-code platform used to visually build business applications and databases without the need for coding. It has an easy-to-use drag and drop interface that allows anyone to quickly create powerful, customizable solutions to fit their needs.Some key features of Ninox include:Intuitive visual database builder to connect data...
NuBuilder Forte
nuBuilder Forte is a powerful rapid prototyping tool for designing advanced natural user interfaces (NUIs). It provides a visually rich drag and drop interface for building NUIs that incorporate technologies like:Multi-touch gesturesVoice commandsGaze trackingIn-air gesturesFacial expressionsObject and motion sensorsWith nuBuilder Forte, designers can focus on innovating and iterating, without needing...
My Visual Database
My Visual Database is a powerful yet easy-to-use database builder for non-technical users. With its visual, drag-and-drop interface, anyone can quickly create relational databases, build tables with different field types, set up relationships between tables, and construct customized forms and views for entering and accessing data.Unlike traditional database programs that...
Grist
Grist is a cloud-based collaborative spreadsheet and database application designed for teams that need to manage structured data. It combines the flexibility of a spreadsheet with the structured data capabilities of a database.Some key features and benefits of Grist include:Flexible data modeling - Grist allows you to create custom data...
VFront
VFront is an open-source website builder designed to allow anyone to create professional, modern websites without needing to know how to code. It features an intuitive drag-and-drop interface that makes building websites as easy as dragging website elements onto a canvas and arranging them however you like.With VFront, you can...
Symphytum
Symphytum is an open-source, cross-platform software synthesizer, sampler, and digital audio workstation. It was created to be a free and accessible tool for music production, composition, and performance.Some key features of Symphytum include:Powerful synthesizer engine for generating and manipulating soundsIntuitive graphical interface for connecting modules and routing audioSupport for VST...
Simpl4
simpl4 is an open-source, self-hosted project management application. It is designed from the ground up to provide teams with an intuitive yet powerful tool to plan, track and collaborate on projects of any size.Some key features of simpl4 include:Kanban boards to visualize workflow and track progressRoadmaps to plan out projects...
DbFacePHP for MySQL
DbFacePHP for MySQL is an open source web application framework built specifically for PHP and MySQL. It simplifies building database-driven web applications by handling common tasks like:Database access - Provides an ORM for mapping MySQL data to PHP objectsTemplating - Includes a fast templating engine for separating code and presentationRouting...
DbGate
DbGate is a versatile database management tool that provides a single interface to connect to and manage multiple databases. Some key features of DbGate include:Supports popular databases like MySQL, PostgreSQL, SQL Server, SQLite, and moreIntuitive GUI for easy database access, querying, and administrationTabbed interface to manage multiple database connectionsDatabase explorer...
SeaTable
SeaTable is an open-source, self-hosted file collaboration and management platform for teams. It allows organizations to take control over their data by hosting files on their own servers, rather than relying on third-party cloud services.With SeaTable, teams can store, sync, search, share, and collaborate on files, much like they would...
MDB Viewer Plus
MDB Viewer Plus is software that allows you to view, edit, and create Microsoft Access (MDB/ACCDB) database files without having Microsoft Access installed. It can be used as a free alternative to Access for basic database operations.Some key features of MDB Viewer Plus include:Open, view, edit, and save MDB and...
PDOCrud
PDOCrud is an open source PHP library that simplifies database CRUD operations when using PDO. It abstracts away much of the repetitive code needed when working with databases in PHP.Some key features of PDOCrud include:Easy connect to MySQL, PostgreSQL, SQLite, SQL Server, etc. databases using PDOSimple high-level methods like find(),...
Matrify
Matrify is a versatile matrix calculator and visualization software designed to make working with matrices easy and intuitive. It provides a graphical interface where users can enter matrices, edit them by adding/deleting rows and columns, and perform various matrix operations including addition, subtraction, multiplication, finding determinants, inverses, etc.Some key features...
IBM Lotus Approach
IBM Lotus Approach is a discontinued Windows-based database software that was developed and sold by IBM Lotus Software in the 1990s. It combined relational database capabilities with integrated office productivity tools such as word processing, spreadsheet, e-mail, calendar, and time management.Some key features of Lotus Approach include:Relational database for storing,...
Dashboard for MySQL
Dashboard for MySQL is an open source web-based application designed to help database administrators and developers visualize, monitor, and optimize the performance of MySQL databases. Some key features include:Customizable dashboards showing key MySQL metrics like connections, traffic, query throughput, top queries, hosts, replication status, etc.Visual graphs and charts for time-series...
HSQLDB
HSQLDB (HyperSQL DataBase) is an open-source relational database management system (RDBMS) written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes.Key features of HSQLDB include:Full support for standard SQL, JDBC API and PCI driversEmbedded, in-process, memory-only...
ElectroCRUD
ElectroCRUD is an open-source rapid application development tool that auto-generates admin interfaces for relational databases. It integrates deeply with PostgreSQL, MySQL, and SQLite to introspect the schema and generate a feature-rich admin UI including:Lists, create, edit, and view forms for database tablesSorting, filtering, searching, and pagination for listsInput validation and...
H2 Database Engine
The H2 Database Engine is an open-source relational database management system written in Java. It can be embedded in Java applications or run in client-server mode, with either TCP or disk-based database files.Some key features of H2 include:Small footprint - The H2 jar file is around 2MB and it has...
CSV Query
CSV Query is an open-source command-line tool for querying and manipulating CSV files. It provides a SQL-like language specifically designed for CSV data that allows users to slice, filter, aggregate, transform, and visualize data from CSV files without writing any code.With CSV Query, users can perform data analysis tasks such...
Basetool
Basetool is an intuitive and feature-rich open-source database modeling and design tool. It enables developers and database administrators to visually model, design, and manage relational database systems with ease.With Basetool, you can quickly create ER diagrams and relational schemas through simple drag-and-drop interfaces. It supports detailed database modeling using various...
Alpha Five
Alpha Five is a low-code platform used by businesses to develop custom database applications and web apps quickly and easily. It utilizes a visual development environment and drag-and-drop tools to build the full stack without hand-coding.With Alpha Five, you can create professional-looking forms, reports, charts, dashboards and other business applications...
Rowy
Rowy is a unique spreadsheet and database software that combines the flexibility of spreadsheets with the structure of databases. It gives users the ability to build customized tables, forms, and views to manage their data, without needing any coding or prior technical expertise.Some key features of Rowy include:Intuitive drag-and-drop interface...
DbFront
dbFront is an open-source web-based database frontend that allows users to easily manage multiple databases through one simple and consistent interface. It can connect to MySQL, PostgreSQL, SQL Server, SQLite, and other major database platforms.Some key features of dbFront include:Intuitive dashboard interface for browsing database objects like tables, views, stored...
XCRUD
xCRUD is an open-source rapid application development tool that helps developers build CRUD (create, read, update, delete) web applications for relational databases in minutes without writing any code. It's a low-code framework that generates a full admin interface and REST API for managing database content out of the box.With an...
SpeedBase Professional
SpeedBase Professional is a desktop database application used by small and medium-sized businesses to build custom databases tailored to their needs. With an easy-to-use visual interface, non-technical users can quickly create tables, relationships, forms, reports and more without any coding required.Key features include:Intuitive drag-and-drop interface to design databasesOptions to create...
QuintaDB
QuintaDB is an open-source, high-performance time-series database optimized for analytics. It is designed to efficiently store and analyze numeric sensor data that is constantly being generated over time, known as time-series data.Some key features and benefits of QuintaDB include:Specialized optimization for the time-dimension in time-series data workloadsColumnar storage and advanced...
Tiki Trackers
Tiki Trackers is a flexible project management software designed for agile teams. It provides a variety of tools to help plan, organize, and track projects more efficiently.Some key features of Tiki Trackers include:Kanban boards for visualizing work and limiting work-in-progressCustomizable workflows to match your team's processTask dependencies and Gantt charts...
Steward Database
Steward Database is an open-source database application designed for simplicity and ease of use. It provides an intuitive graphical user interface that allows users to easily explore, visualize, and make sense of their data.Some key features of Steward Database include:Visual query builder - Build queries by simply pointing and clicking,...
LyteRAD
LyteRAD is an open-source, lightweight rapid application development (RAD) tool for building desktop applications. It features a drag-and-drop interface that allows developers to quickly assemble graphical user interfaces by adding widgets like buttons, text boxes, lists, and more without writing a lot of boilerplate code.Some key capabilities and benefits of...
Databuilder.io
Databuilder.io is an open-source data modeling and ETL (extract, transform, load) pipeline building tool. It provides a graphical interface and drag-and-drop components to enable users to quickly model, validate, transform, and load large volumes of data without having to write any code.Some key capabilities and benefits of Databuilder.io include:Intuitive graphical...
Actual ODBC Driver for Access
The Actual ODBC Driver for Access is a comprehensive connectivity solution that allows you to connect your Access databases to a wide range of applications and tools through the ODBC interface. It provides standardized, robust and secure access to Access data for business intelligence, analytics, reporting, migration, custom programming, and...
Runabase
Runabase is a cloud-based database, spreadsheet, and collaboration software designed for teams that need to manage data and work together in real-time. It combines the flexibility of a spreadsheet with the structured data management capabilities of a database.Key features of Runabase include:Real-time collaboration - Multiple users can view, edit, comment...
ACCDB MDB Explorer
ACCDB MDB Explorer is a desktop software application designed specifically for working with Microsoft Access database files. It allows you to open, view, edit, and extract data from Access 2007-2019 ACCDB/MDB files without requiring Microsoft Access installed.Key features include:View and browse Access object structure including tables, queries, forms, reports, macros,...
Meld Tables
Meld Tables is a versatile software tool for comparing, merging, and synchronizing tabular data between spreadsheets, CSV files, and databases. With its intuitive visual interface, Meld Tables makes it easy to analyze differences between two or more tables, selectively merge changes from one version to another, and set up automatic...
Kexi
Kexi is a free and open source visual database design, data analysis and data management application for the desktop aimed at both novice and expert users. Built on Qt software and the KDE Frameworks technologies, it features a slick graphical user interface that allows users to create and manage databases,...
Glom
Glom is an open-source GUI database management and design tool for creating relational databases without programming knowledge. It allows users to visually design database schemas, tables, forms, reports and queries to build full-featured database applications.Some key features of Glom include:Visual database designer for creating tables, relations, forms and reports without...
GS-Base
GS-Base is a desktop-based GIS software application designed specifically for file management, editing, analysis, and data maintenance of spatial data. It serves as a central hub and single source of truth for an organization's geospatial data assets and related workflows.Some key capabilities and benefits of GS-Base include:Intuitive and easy-to-use interface...
Suneido
Suneido is an integrated application development system designed for rapidly building database-backed applications. It combines an object-oriented programming language, database, and integrated development environment (IDE) into a small self-contained package.Some key features of Suneido include:Object-oriented language with a syntax similar to Java or C#Integrated RDBMS with support for transactions, queries,...
NSBase
NSBase is an open-source alternative to Airtable that allows you to create flexible, customizable databases to organize information. Like Airtable, NSBase uses a spreadsheet-database hybrid model that enables you to structure data into tables with different views and forms.Key features of NSBase include:Intuitive drag-and-drop interface for building databases without codingCustom...
Xataface
Xataface is an open source web application framework and content management system (CMS) designed for developing database-driven web applications. It enables rapid application development without writing code by automatically generating a full create, read, update, and delete (CRUD) interface from a MySQL, PostgreSQL, SQLite, or other SQL database schema.Some key...
Mimer SQL
Mimer SQL is a relational database management system developed by the Swedish company Mimer Information Technology. It supports the SQL standards, including support for transactions, referential integrity, triggers and stored procedures.Some key features of Mimer SQL include:Small footprint - The database server executable is around 1MB in size, making it...
Referata
Referata is an open-source wiki and knowledge base software built using PHP and MySQL. It was created to provide an easy-to-use platform for teams to collaborate, share information, and build a searchable repository of documentation and institutional knowledge.Some key features of Referata include:WYSIWYG editor for easy editing without learning wiki...
Viewer for Access Database
Viewer for Access Database is a free, open-source tool that provides read-only access to Microsoft Access databases (mdb and accdb file formats) without requiring Microsoft Access to be installed. It allows you to open, view data and objects, print reports and forms, and search within Access databases on any Windows...
DBworx
dBworx is a comprehensive suite of professional audio plug-ins and tools used for audio editing, processing, mastering, and restoration. Developed by Michael Rozenblit, it features a wide range of effects and capabilities to enhance audio quality, remove unwanted sounds, and prepare audio for professional use.Some of the key features and...
WowBase
WowBase is a free photo catalog program designed to help organize personal photo collections. It provides features such as:Importing photos from folders on hard drivesTagging photos with keywords and descriptionsCategorizing photos into user-defined albums and eventsSearching and filtering by text, tags, date ranges, etc.Viewing photos in a gallery interface with...
Viravis
Viravis is a free, open-source digital painting and illustration software application. It is designed to provide tools for artists to create digital artwork from scratch.Some of the key features of Viravis include:Intuitive user interface with customizable brushes, colors, layers, and tools for sketching, painting, and illustration.Support for common graphics file...
Limbas
Limbas is an open-source project management software application designed as an alternative to Microsoft Project. It provides a suite of tools for planning, scheduling, resource allocation, collaboration, and progress tracking for projects.Key features of Limbas include:Intuitive Gantt chart interface for visualizing project tasks, timelines and dependenciesResource management tools for assigning...
Elastictable
Elastictable is an innovative spreadsheet application aimed at teams who need to work with data. It combines the familiar grid layout of traditional spreadsheets with more advanced tools for data analysis, visualization, and collaboration.Key features include:Intuitive spreadsheet interface making it easy to enter, organize and adjust dataVariety of powerful charts...
Csvsql
csvsql is an open-source command-line tool that allows you to execute SQL queries on CSV files without the need to load them into a database first. It supports most common SQL operations like SELECT, JOIN, GROUP BY, ORDER BY etc. making it easy to analyze and manipulate CSV data.Some key...
InfoDome
InfoDome is a powerful knowledge management and collaboration platform for organizing business information and improving productivity. It consolidates all your organization's documents, web pages, images and other content into a centralized, searchable database.Key features of InfoDome include:- Intuitive user interface for uploading, organizing and sharing content- Advanced search with filtering,...
Qbase
Qbase is a versatile open-source database management system that provides comprehensive tools for data warehousing, analytics, and reporting needs. Some of its key features include:Powerful Extract, Transform, and Load (ETL) functionalities for managing data integration.Data warehousing capabilities to organize and model your data for analytics.SQL query editor with auto-complete, syntax...
Handy Application Maker
Handy Application Maker is a powerful yet user-friendly application building platform for quickly creating custom desktop software tailored to your needs, without writing any code.It features an intuitive drag-and-drop interface that allows you to easily add and customize various components like forms, tables, charts, buttons, and more to build full-featured...
SysInfo MDB Viewer
SysInfo MDB Viewer is a lightweight, cross-platform application for working with Microsoft Access database (MDB/ACCDB) files. As an open source tool, it is completely free to use and distribute.Some of the key features of SysInfo MDB Viewer include:Open, view, and browse MDB/ACCDB databasesView all database objects like tables, queries, forms,...
MDBLite
MDBLite is an open-source, lightweight, document-oriented database that retains many of the key features of MongoDB while being more resource-efficient. Like MongoDB, MDBLite stores data in flexible JSON-like documents rather than tables in rows and columns. This allows for heterogeneous data types to be stored together and for documents to...
SAP MaxDB
SAP MaxDB is a relational database management system originally developed by MySQL and then by SAP SE. It is optimized for use with SAP business applications such as SAP ERP, SAP CRM, SAP SCM, and SAP SRM.Some key capabilities and benefits of SAP MaxDB include:High performance for transactional and analytical...
SysInfo SQL Viewer
SysInfo SQL Viewer is a powerful, easy-to-use database query and reporting tool designed specifically for database administrators, developers, business analysts and others who need to access and analyze data from relational databases like SQL Server, Oracle, DB2, MySQL, PostgreSQL and more.With an intuitive graphical interface, SysInfo allows users to quickly...
