Automate Database Operations with LibreOffice Base

This skill drives LibreOffice Base to create, manage, and automate database workflows using the native ODB (OpenDocument Database) format. It covers database creation (building new ODB files from scratch, designing tables, views, and relationships, and creating embedded HSQLDB or Firebird databases), data operations (importing from CSV or spreadsheets, exporting to various formats, running and managing queries, and batch data processing), form and report automation (data entry forms, custom reports, and templates), and SQL/query work (visual query design, SQL execution, optimization, and result-set manipulation).

Use this skill when you need to create a new ODB database, connect Base to an external database engine such as MySQL, MariaDB, or PostgreSQL, or automate database operations, forms, and reports instead of doing them by hand in the Base GUI. It also applies to routine maintenance work: using parameterized queries, adding indexes for performance, running regular backups, wrapping changes in transactions for data integrity, and keeping ODB source files under version control. It is not a substitute for direct SQL access when no ODB layer is involved, and generated output should still go through environment-specific validation and testing rather than being trusted blind for production use.

The skill can create embedded databases (HSQLDB, Firebird) or connect to external ones over dedicated connection strings, for example sdbc:mysql:jdbc:mysql://localhost:3306/database, sdbc:postgresql://localhost:5432/database, sdbc:sqlite:file:///path/to/database.db, and sdbc:odbc:DSN_NAME. Supported external sources include MySQL/MariaDB, PostgreSQL, SQLite, and ODBC/JDBC data sources. On the data side it imports from CSV files and spreadsheets and exports to various formats, alongside batch data processing and query-driven reporting. Command-line entry points include soffice --base to open Base directly, and soffice --headless --accept="socket,host=localhost,port=8100;urp;" to expose a socket for scripted automation. Outputs are ODB database files, forms, reports, and query result sets.

soffice --base

Automation runs through Python's UNO API (import uno), which resolves a socket bridge to the running LibreOffice process so a script can create a DatabaseDocument, set its data source URL and credentials, and store it as an .odb file. Two Python libraries are named for this work: pyodbc for ODBC connectivity and sqlalchemy as a general SQL toolkit. If the automation socket gets stuck, the fix is killall soffice.bin followed by restarting soffice --headless --accept="socket,host=localhost,port=8100;urp;". Connection issues beyond that are traced by checking that the database server is running, confirming the connection-string format, verifying JDBC/ODBC drivers are installed, and confirming network connectivity.

Anyone building or automating relational-database workflows on top of LibreOffice Base: people connecting Base to an existing MySQL or PostgreSQL backend, scripting database creation and reporting with Python and UNO, or wiring Base into a CLI-driven pipeline via JDBC/ODBC. Related skills in the same family are writer, calc, impress, draw, and workflow-automation.