skills.rest
tobiascm
tobiascmCOMMUNITY
Explore all skills by this author →
GitHub

skill-budget-stundensaetze

Retrieves hourly rates from BPOUS-NG via OE and cost-center APIs into local SQLite.

Updated Aug 27, 2026
Search Tags:#analytics#database#cost-center#hourly-rate#stundensatz#bplus-ng#org-unit
One-click install
npx skills add https://github.com/tobiascm/vobes-agent-vscode --skill skill-budget-stundensaetze
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: skill-budget-stundensaetze
Source: https://github.com/tobiascm/vobes-agent-vscode/tree/main/.agents/skills/skill-budget-stundensaetze
Command: npx skills add https://github.com/tobiascm/vobes-agent-vscode --skill skill-budget-stundensaetze

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Stundensätze aus BPLUS-NG/EK-Reports in die lokale SQLite-DB laden, damit du Stundensätze nach OE, Kostenstelle und Jahr schnell abrufen kannst.

Core Features & Use Cases

  • Sync: Aktualisiert den Cache der Stundensaetze (OE + Kostenstelle) aus BPLUS-NG.
  • Query: Abfragen der Stundensaetze per SQL und Ausgabe als Markdown-Tabelle.
  • Kontext/Quellen: Nutzt REST-APIs OrgUnit/GetAll und CostCenter/GetCostCenter2HourlyRates, um OE-, KST- und Jahresdaten zu liefern.
  • Beispiel-Use-Case: Ein Admin möchte den Stundensatz der OE EKEK/1 oder einer bestimmten Kostenstelle prüfen und in Berichte integrieren.

Quick Start

Synchronisiere zuerst die Stundensätze in der lokalen Datenbank und führe anschließend eine Abfrage aus, um die Ergebnisse als Markdown-Tabelle anzuzeigen.

Frequently Asked Questions about skill-budget-stundensaetze

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I retrieve hourly rates from BPLUS-NG by cost center and organizational unit?▼

You can fetch BPLUS-NG hourly rates by syncing data from the OrgUnit/GetAll and CostCenter/GetCostCenter2HourlyRates REST APIs into a local SQLite database, then querying it by organizational unit or cost center.

Can I analyze hourly rates across multiple years using a local database?▼

Yes, you can perform OE-based rate analysis across years by syncing hourly rates from BPLUS-NG into a local SQLite database and executing SQL queries to compare historical data.

What is the best way to cache BPLUS-NG stundensaetze for quick SQL queries?▼

The best way to cache stundensätze is to fetch them via the BPLUS-NG REST APIs and store the records in a local SQLite database, enabling fast offline SQL querying by OE, cost center, or year.

Does this approach require specific REST API endpoints to fetch OE and cost center rates?▼

Yes, retrieving OE and cost center rates requires the specific BPLUS-NG REST API endpoints OrgUnit/GetAll and CostCenter/GetCostCenter2HourlyRates to populate the local database successfully.

How do I format SQLite query results into a Markdown table in VS Code?▼

After querying the local SQLite database for hourly rates, the results are formatted and output as a Markdown table directly within VS Code for easy integration into reports.

Related Skills

Explore More Data & Analytics Skills→
adrianweddadrianwedd
8

customer-lookup

Retrieve customer data and order history from Lemon Squeezy by email or ID.

Community
Intermediate
jhd3197jhd3197
666

db-inspect

Inspect ServerKit SQLite schemas, row counts, and run SQL queries.

Community
Intermediate
alongor666alongor666
1

vue-component-dev

Develop Vue 3 components with Pinia stores and ECharts charts.

Community
Intermediate
pnils08pnils08
1

godworld-sync

Sync GodWorld cycle exports into a local SQLite database.

Community
Intermediate