Automate Database Operations with LibreOffice Base

LibreOffice Base skill for creating, managing, and automating database workflows using the native ODB (OpenDocument Database) format. It creates new ODB databases from scratch, designs tables, views, and relationships, and can create embedded HSQLDB or Firebird databases as well as connect to external databases (MySQL/MariaDB, PostgreSQL, SQLite, and ODBC or JDBC data sources). It handles data operations - importing data from CSV files and spreadsheets, exporting to various formats, running and managing queries, and batch data processing - and automates form and report work: creating data entry forms, designing custom reports, automating report generation, and building form templates. For queries it supports visual query design, SQL execution, query optimization, and result-set manipulation. Automation is available via command-line invocation, Python scripting through the UNO API, and JDBC/ODBC connectivity.

soffice --base

Use it when creating new databases in ODB format, connecting to external databases, automating database operations and reports, creating forms and reports, or building database applications with LibreOffice Base. It is not a substitute for environment-specific validation, testing, or expert review of the resulting database or automation, and the skill should stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.

Inputs are database creation or connection parameters (host, port, database name, user, password for external databases) and, for scripted use, a running LibreOffice UNO socket listener. Output is an ODB database file, a connected data source, populated tables, forms, or reports, or query results, depending on the workflow invoked - created via the command line or through Python UNO calls such as creating a com.sun.star.sdb.DatabaseDocument and storing it to a file URL.

It connects to HSQLDB and Firebird (embedded), MySQL/MariaDB, PostgreSQL, SQLite, and generic ODBC/JDBC data sources, using connection strings such as sdbc:mysql:jdbc:mysql://host:port/database, sdbc:postgresql://host:port/database, sdbc:sqlite:file:///path/to/database.db, and sdbc:odbc:DSN_NAME. On the Python side it relies on the pyodbc and sqlalchemy libraries for ODBC connectivity and SQL tooling. It is one of a related set of LibreOffice skills covering Writer, Calc, Impress, Draw, and general workflow automation.

It follows a set of stated best practices: use parameterized queries, create indexes for performance, back up databases regularly, wrap changes in transactions for data integrity, store ODB source files in version control, document the database schema, use appropriate data types, and handle connection errors gracefully. For a stuck UNO socket, the documented recovery is to kill the running soffice.bin process and relaunch it headless with an explicit socket listener; for other connection failures it checks that the database server is running, the connection string format is correct, the required JDBC/ODBC drivers are installed, and network connectivity is intact.

Anyone automating LibreOffice Base database work from the command line or Python - building ODB databases, wiring up forms and reports, or scripting connections to an external database engine.