scaffold-banking-app

name	scaffold-banking-app
description	Creates a complete banking cash flow application with SQLite database, demo data, and web UI. The initial UI includes placeholder functionality that displays "Skill missing" for features not yet implemented.
triggers	["create the banking application","scaffold banking app","build the banking application","set up banking app"]

scaffold-banking-app

This skill creates a complete Corporate Cash Flow Analysis application for "Apex Manufacturing Inc." with:

• SQLite Database: 8 tables containing demo treasury data
• Web UI: Responsive dashboard with light/dark mode
• HTTP Server: Python-based server on port 8080
• Demo Data: ~$12.5M across 5 bank accounts, 17 receivables, 10 payables, 1 credit facility

Execution Order

Create the following scripts in the workspace root directory, then execute them in order:

1. create_app_structure.py - Creates the banking_app directory structure with subdirectories for database, static files, CSS, JS, API modules, and scripts.

2. init_database.py - Initializes SQLite3 database at banking_app/database/corporate_cashflow.db with 8 tables: companies, bank_accounts, transactions, customers, receivables, vendors, payables, credit_facilities.

3. seed_demo_data.py - Populates database with Apex Manufacturing Inc. demo data including 5 bank accounts, 8 customers, 17 receivables, 8 vendors, 10 payables, and 1 revolving credit facility.

4. generate_frontend.py - Creates responsive HTML/CSS/JS frontend with navy blue (#1A365D) and gold (#C9A227) color scheme, Quick Actions cards, and dark mode toggle.

5. Validation Step - After generating the frontend, verify and auto-correct the static file paths in banking_app/static/index.html:

   • CSS path MUST be /css/styles.css (NOT /static/css/styles.css)
   • JS path MUST be /js/app.js (NOT /static/js/app.js)

   Why this matters: The server serves files from the static directory as root. Using /static/... paths causes 404 errors because the server looks for static/static/... which doesn't exist.

6. generate_server.py - Creates Python HTTP server at banking_app/server.py serving static files and API endpoints on port 8080.

Usage

After execution, start the application:

cd banking_app
python server.py

Then open http://localhost:8080 in your browser.

Verification Step

After starting the server, verify that static files are being served correctly by running this command in a separate terminal:

# Check that CSS is served correctly (should return CSS content, not 404)
curl -s -o /dev/null -w "%{http_code}" http://localhost:8080/css/styles.css

Expected result: 200

If you get 404, the HTML file paths are incorrect. Stop the server and re-run the validation step from the Execution Order.

Note

The Cash Position button will display "Skill Missing" until the add-cash-position-feature skill is executed.