AI-powered skills for navigating and developing TSQL.APP applications
Click to watch how the TSQL.APP skills work in action
TSQL.APP is a revolutionary metadata-driven application framework where everything is defined in database tables, not code.
┌─────────────────────────────────────────────────────────┐
│ TSQL.APP Architecture │
├─────────────────────────────────────────────────────────┤
│ │
│ 📊 Business Database 📋 Meta Database │
│ ───────────────────── ───────────────────── │
│ • Your actual data • Cards (screens) │
│ • Tables & Views • Fields (columns) │
│ • Stored Procedures • Actions (buttons) │
│ • Business Logic • Children (relations) │
│ │
│ Database = Code + UI + Logic │
│ │
└─────────────────────────────────────────────────────────┘
Understand and navigate TSQL.APP applications
| Capability | Description |
|---|---|
| 🔗 URL Parsing | Decode any TSQL.APP URL into card, filters, sorting, selection |
| 🔘 Action Discovery | List all buttons, filters, and sub-menus with keyboard shortcuts |
| 👶 Relationship Mapping | Explore parent-child card hierarchies |
| ⌨️ Shortcut Sequences | Show full keyboard paths (e.g., K → N) |
| 🔮 Navigation Prediction | Predict next URL after user actions |
Example prompts:
"What does this URL mean: https://app.example.com/orders?ord=123d&red=Open"
"What buttons are available on the orders card?"
"What happens when I press Enter on this screen?"
Generate production-ready TSQL.APP code
| Capability | Description |
|---|---|
| 📝 Action Scripts | Create button logic with proper patterns |
| 🖼️ Modal Forms | Build forms with state management |
| ✅ Code Validation | Enforce 11 mandated practices |
| 🔍 Procedure Verification | Check against 1500+ documented procedures |
| 🎯 First-Time-Right | Production-ready code, no placeholders |
Example prompts:
"Create a modal form for adding a new customer"
"Write an action script to update invoice status"
"Build a data entry form with validation"
- Download the
.skillfile from Releases - Upload to Claude via the skills interface
| Skill | Download | Size |
|---|---|---|
| tsqlapp-navigator | ⬇️ Download | ~10 KB |
| tsqlapp-developer | ⬇️ Download | ~50 KB |
TSQL.APP URLs capture complete application state:
https://domain/card[/parent_id/child]?ord=field[d]&red=filter&id=record
│ │ │ │ │ │ │ │
│ │ │ │ │ │ │ └── Selected record
│ │ │ │ │ │ └── Active filter
│ │ │ │ │ └── d = descending
│ │ │ │ └── Sort by field ID
│ │ │ └── Child card (detail view)
│ │ └── Parent record ID
│ └── Card name (screen)
└── Your domain
| URL | Meaning |
|---|---|
/orders |
Orders list |
/orders?ord=5d |
Orders sorted by field 5, descending |
/orders?red=Open |
Orders with "Open" filter active |
/orders/123/lines |
Order lines for order #123 |
/orders?id=456 |
Orders with record 456 selected |
┌────────────────────────────────────────────────────────────────┐
│ Meta Tables │
├────────────────────────────────────────────────────────────────┤
│ │
│ api_card api_card_actions api_card_children│
│ ┌──────────────┐ ┌──────────────┐ ┌──────────────┐ │
│ │ id │ │ id │ │ parent │ │
│ │ name ◄────┼──────┼─ card_id │ │ child │ │
│ │ tablename │ │ name │ │ ref │ │
│ │ basetable │ │ action │ │ keycode │ │
│ │ reducer │ │ keycode │ │ reducer │ │
│ └──────────────┘ │ group_id ◄───┼──┐ └──────────────┘ │
│ │ sql │ │ │
│ api_card_fields └──────────────┘ │ │
│ ┌──────────────┐ │ │ │
│ │ id │ └──────────┘ │
│ │ card_id │ (sub-menus) │
│ │ name │ │
│ │ list_order │ │
│ └──────────────┘ │
│ │
└────────────────────────────────────────────────────────────────┘
Contributions are welcome!
- Fork the repository
- Create your feature branch (
git checkout -b feature/amazing-feature) - Commit your changes (
git commit -m 'Add amazing feature') - Push to the branch (
git push origin feature/amazing-feature) - Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details.
Built with ❤️ for the TSQL.APP community