Agent skill · data analytics · aiskillstore
base
Database management, forms, reports, and data operations with LibreOffice Base.
Why this skill is useful
Adds Python scripts for database automation and specific connection patterns that the AI wouldn't reliably generate on its own.
What it needs
Requires pyodbc, python, sqlalchemy installed locally. About 2k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
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 Method 2: Python with UNO Connecting to External Database Database Connection Reference Supported Database Types HSQLDB (embedded) Firebird (embedded) MySQL/MariaDB PostgreSQL SQLite ODBC data sources JDBC data sources Connection Strings Command-Line Reference Python Libraries Best Practices 1. Use parameterized queries 2. Create indexes for performance 3. Backup databases regularly 4. Use transactions for data integrity 5. Store ODB source files in version control 6. Document database schema 7. Use appropriate data types 8. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/base