base
Database management, forms, reports, and data operations with LibreOffice Base.
new
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
soffice --baseMethod 2: Python with UNO
import uno
def create_database():
local_ctx = uno.getComponentContext()
resolver = local_ctx.ServiceManager.createInstanSubscribers only
The full skill, its 1 bundled files and every download is included with every paid Complete AI plan.
Details
| Source | personal |
|---|---|
| License | — |
| Risk label | safe ("critical" means the skill may run commands or touch files — read before use) |
| Files | SKILL.md |
| Added | 2026-02-27 |
Related skills
database-admin
Expert database administrator specializing in modern cloud databases, automation, and reliability engineering.
database-architect
Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures.
database-design
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
database-optimizer
Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.
using-neon
Neon is a serverless Postgres platform that separates compute and storage to offer autoscaling, branching, instant restore, and scale-to-zero. It's fully compatible with Postgres and works with any language, framework, or ORM that supports Postgres.