Hi - I answer from the OpenSmartRoute documentation: routing, the API, plans and quotas, self-hosting. Ask away, or open a support ticket if you need a person.
Grounded in the docs - follow a source before acting on it.
database-operations - Skill - OpenSmartRoute
Skillv1.0.0
database-operations
Instructions on how to write database queries with SQLAlchemy.
Imported from ComeOnOliver/skillshub (skills/aiskillstore/marketplace/crossbill-highlights/database-operations/SKILL.md). Install upstream with npx skills add ComeOnOliver/skillshub --skill database-operations. Copyright stays with the author.
When performing database operations using SQLAlchemy, follow these guidelines to ensure efficient and maintainable code:
Avoid for-loops. Instead always prefer bulk operations using SQLAlchemy's built-in methods or use SQL joins to get related data in a single query.
Database operations should be contained in repository classes
Use it
Copy one of these into your project. Installing also returns the manifest and these snippets.
# after Install: the listing is in your workspace's routing pool - a plan picks it for its slot
curl -s -X POST https://api.opensmartroute.ai/api/v1/route -H 'Authorization: Bearer $OSR_API_KEY' -H 'Content-Type: application/json' -d '{"text": "...", "plan": true}'
Manifest
An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.
