skills.rest
AnasIsmai1
AnasIsmai1COMMUNITY
Explore all skills by this author →
WebsiteGitHub

base

Create and automate LibreOffice Base databases, forms, reports, and SQL queries.

Updated Sep 20, 2024
Search Tags:#automation#database#sql#libreoffice#base#uno#odb
One-click install
npx skills add https://github.com/AnasIsmai1/dotfiles --skill base-anasismai1
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: base
Source: https://github.com/AnasIsmai1/dotfiles/tree/main/claude/.claude/skills/libreoffice/base
Command: npx skills add https://github.com/AnasIsmai1/dotfiles --skill base-anasismai1

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pyodbc, sqlalchemy.

What problem does it solve? Managing databases through manual GUI work is slow and hard to reproduce. This Skill provides structured guidance for creating ODB databases, connecting to external data sources, and automating forms, reports, and queries with LibreOffice Base and Python UNO scripting. ## Core Features & Use Cases - Database Creation: Build new ODB databases with embedded HSQLDB or Firebird, or connect to MySQL, PostgreSQL, SQLite, ODBC, and JDBC sources. - Automation with UNO: Use Python and the UNO API to create database documents, configure data sources, and run operations headlessly. - Forms, Reports, and SQL: Design data entry forms, generate reports, and execute SQL queries with connection string references. - Use Case: Connect LibreOffice Base to a remote MySQL server, store the connection as an ODB file, and automate report generation from live query results. ## Quick Start Ask the assistant to create a new LibreOffice Base ODB database and connect it to your MySQL server using a Python UNO script.

Frequently Asked Questions about base

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a LibreOffice Base database from the command line?▼

Run soffice --base to launch the Base database wizard, or use a Python UNO script that creates a com.sun.star.sdb.DatabaseDocument instance and stores it as an ODB file with storeToURL.

How to connect LibreOffice Base to MySQL or PostgreSQL?▼

Set the data source URL on the DatabaseDocument using an sdbc connection string, such as sdbc:mysql:jdbc:mysql://host:3306/database for MySQL or sdbc:postgresql://host:5432/database for PostgreSQL, then provide username and password properties.

What databases does LibreOffice Base support?▼

Base supports embedded HSQLDB and Firebird databases plus external connections to MySQL, MariaDB, PostgreSQL, SQLite, and generic ODBC or JDBC data sources through sdbc connection strings.

Why does the UNO socket connection fail in LibreOffice?▼

The socket fails when a soffice process is already running without a listener. Kill existing processes with killall soffice.bin, then start headless mode with soffice --headless --accept="socket,host=localhost,port=8100;urp;".

Can I automate LibreOffice Base with Python?▼

Yes, use the pyuno bridge to connect to a running soffice instance over a socket, then create database documents, configure data sources, and store ODB files programmatically. Optional libraries like pyodbc and sqlalchemy extend connectivity.

Related Skills

Explore More Data & Analytics Skills→
awsaws
2.3k

connecting-to-data-source

Register and validate AWS Glue connections to external data sources.

Official
Advanced
wuyyyyyouwuyyyyyou

recipe-backup-sheet-as-csv

Export a Google Sheets spreadsheet to a CSV file for local backup.

Community
Intermediate
armanzeroeightarmanzeroeight
29

schema-designer

Design normalized relational database schemas with SQL constraints and indexes.

Community
Intermediate
autorundevautorundev
1

db-migrations

Automate database migrations for Python applications using Alembic and raw SQL.

Community
Advanced