# Build LibreOffice Base Database Workflows

Database setup and automation across LibreOffice Base can require unfamiliar connection formats and UNO services. This skill provides focused workflows, examples, and operational guidance.

## Install

```bash
npx skillstore add sickn33/base
```

## Metadata

- Status: approved
- Slug: sickn33-base
- Skillstore revision: r2
- Version status: missing
- Tree hash: a5209d39f168d4c41bc0cfc71e16fd9850eb5d34640430c0c192c89a6f7d04f8
- Author: sickn33
- GitHub username: sickn33
- License: MIT
- Repository: https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/libreoffice/base
- Ref: 5a26d1d61d694db29af9b138c661c1981076d9df
- Supported tools: Claude, Codex, Claude Code
- Audit status: complete
- Agent install advisory: allowed
- Manual install advisory: allowed
- Artifact signature: available
- Audit attestation: unavailable
- Human verification: not\_verified
- Risk factors: external\_commands, network
- Quality score: 69
- Public page: https://skillstore.pages.dev/skills/sickn33-base
- Manifest: https://skillstore.pages.dev/api/skills/sickn33-base/manifest

## Capabilities

- Guides creation of LibreOffice Base databases in ODB format.
- Explains connections for MySQL, PostgreSQL, SQLite, JDBC, and ODBC sources.
- Provides Python UNO examples for creating database documents and data sources.
- Supports planning for tables, queries, forms, reports, imports, and exports.
- Provides command-line startup and localhost UNO socket troubleshooting guidance.

## Use Cases

- Create a Department Database: Design an ODB database with tables, relationships, forms, and routine reports for a small operational team.
- Connect Base to Existing Data: Prepare a LibreOffice Base connection to MySQL, PostgreSQL, SQLite, JDBC, or ODBC data sources.
- Automate Report Production: Plan a Python UNO workflow that opens a database, runs queries, and generates repeatable reports.

## Prompt Templates

### Plan a New Base Database

```
Plan a LibreOffice Base database for [purpose]. Include tables, primary keys, relationships, forms, reports, and validation rules.
```

### Prepare an External Connection

```
Show how to connect LibreOffice Base to [database type]. Use placeholders and list required drivers, connection fields, and verification steps.
```

### Design Queries and Reports

```
Design parameterized queries and reports for [business requirement]. Explain indexes, transactions, expected outputs, and test cases.
```

### Create a UNO Automation Workflow

```
Create a secure Python UNO workflow for [task]. Include listener setup, error handling, secret handling, cleanup, and validation steps.
```

## Limitations

- Requires LibreOffice Base and compatible database drivers in the local environment.
- Examples use placeholder paths, ports, database names, and credentials that require adaptation.
- Does not replace database-specific security, backup, migration, or performance testing.
- UNO automation requires a running LibreOffice listener and environment-specific validation.

## Best Practices

- Use parameterized queries, transactions, indexes, and appropriate data types.
- Back up databases and test changes against non-production copies.
- Keep credentials outside prompts, scripts, connection documents, and version control.

## Anti Patterns

- Do not place real passwords or production connection details in generated examples.
- Do not terminate all LibreOffice processes without checking active work and receiving confirmation.
- Do not apply placeholder commands or connection strings without environment-specific validation.

## Security Audit

- Audited at: 2026-08-14T09:53:47.031\+00:00
- Summary: All 20 static findings are false positives caused by Markdown fences, reference links, placeholder connection text, localhost configuration, or unrelated list text. The review identified two separate medium-severity guidance risks: a broad process termination command and a database example that handles a plaintext password without secure-storage guidance. No prompt injection, malicious network activity, or data exfiltration intent was found.

## Stats

- Views: 109
- Downloads: 16
- Favorites: 0
- Popularity score: 0