base

# 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 uno def create_database(): local_ctx = uno.getComponentContext() resolver = local_ctx.ServiceManager.createInstanceWithContext( "com.sun.star.bridge.UnoUrlResolver", local_ctx ) ctx = resolver.resol...