<< All versions
Skill v1.0.0
currentLLM-judged scan90/100wad-alhoot/ruflow/base
──Details
PublishedOctober 24, 2026 at 12:41 PM
Content Hashsha256:8a22fe9ff48f8921...
Git SHAff5fbef55207
──Files
Files (1 file, 4.2 KB)
SKILL.md4.2 KBactive
SKILL.md · 189 lines · 4.2 KB
version: "1.0.0" name: base description: "Database management, forms, reports, and data operations with LibreOffice Base." category: database-processing risk: safe source: personal date_added: "2026-02-27"
LibreOffice Base
Overview
LibreOffice Base skill for creating, managing, and automating database workflows using the native ODB (OpenDocument Database) format.
When to Use This Skill
Use this skill when:
- Creating new databases in ODB format
- Connecting to external databases (MySQL, PostgreSQL, etc.)
- Automating database operations and reports
- Creating forms and reports
- Building database applications
Core Capabilities
1. Database Creation
- Create new ODB databases from scratch
- Design tables, views, and relationships
- Create embedded HSQLDB/Firebird databases
- Connect to external databases
2. Data Operations
- Import data from CSV, spreadsheets
- Export data to various formats
- Query execution and management
- Batch data processing
3. Form and Report Automation
- Create data entry forms
- Design custom reports
- Automate report generation
- Build form templates
4. Query and SQL
- Visual query design
- SQL query execution
- Query optimization
- Result set manipulation
5. Integration
- Command-line automation
- Python scripting with UNO
- JDBC/ODBC connectivity
Workflows
Creating a New Database
Method 1: Command-Line
bash
soffice --base
Method 2: Python with UNO
python
import unodef create_database():local_ctx = uno.getComponentContext()resolver = local_ctx.ServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver", local_ctx)ctx = resolver.resolve("uno:socket,host=localhost,port=8100;urp;StarOffice.ComponentContext")smgr = ctx.ServiceManagerdoc = smgr.createInstanceWithContext("com.sun.star.sdb.DatabaseDocument", ctx)doc.storeToURL("file:///path/to/database.odb", ())doc.close(True)
Connecting to External Database
python
import unodef connect_to_mysql(host, port, database, user, password):local_ctx = uno.getComponentContext()resolver = local_ctx.ServiceManager.createInstanceWithContext("com.sun.star.bridge.UnoUrlResolver", local_ctx)ctx = resolver.resolve("uno:socket,host=localhost,port=8100;urp;StarOffice.ComponentContext")smgr = ctx.ServiceManagerdoc = smgr.createInstanceWithContext("com.sun.star.sdb.DatabaseDocument", ctx)datasource = doc.getDataSource()datasource.URL = f"sdbc:mysql:jdbc:mysql://{host}:{port}/{database}"datasource.Properties["UserName"] = userdatasource.Properties["Password"] = passworddoc.storeToURL("file:///path/to/connected.odb", ())return doc
Database Connection Reference
Supported Database Types
- HSQLDB (embedded)
- Firebird (embedded)
- MySQL/MariaDB
- PostgreSQL
- SQLite
- ODBC data sources
- JDBC data sources
Connection Strings
# MySQLsdbc:mysql:jdbc:mysql://localhost:3306/database# PostgreSQLsdbc:postgresql://localhost:5432/database# SQLitesdbc:sqlite:file:///path/to/database.db# ODBCsdbc:odbc:DSN_NAME
Command-Line Reference
bash
soffice --headlesssoffice --base # Base
Python Libraries
bash
pip install pyodbc # ODBC connectivitypip install sqlalchemy # SQL toolkit
Best Practices
- Use parameterized queries
- Create indexes for performance
- Backup databases regularly
- Use transactions for data integrity
- Store ODB source files in version control
- Document database schema
- Use appropriate data types
- Handle connection errors gracefully
Troubleshooting
Cannot open socket
bash
killall soffice.binsoffice --headless --accept="socket,host=localhost,port=8100;urp;"
Connection Issues
- Verify database server is running
- Check connection string format
- Ensure JDBC/ODBC drivers are installed
- Verify network connectivity
Resources
Related Skills
- writer
- calc
- impress
- draw
- workflow-automation