Menü
Building full-stack features in Toygres from UI to database. Use when adding new features, API endpoints, React components, or implementing end-to-end functionality.
Mit Codex oder Claude installieren Kopieren Sie diesen Prompt, fügen Sie ihn in Codex, Claude oder einen anderen Assistant ein und lassen Sie die Skill-Seite prüfen und installieren.
Basierend auf der SOC-Berufsklassifikation
| name | fullstack-features |
| description | Building full-stack features in Toygres from UI to database. Use when adding new features, API endpoints, React components, or implementing end-to-end functionality. |
Adding a complete feature from UI to database in Toygres.
toygres-server/src/api.rstoygres-ui/src/lib/types.tstoygres-ui/src/lib/api.tscargo build --workspace && cd toygres-ui && npm run build./deploy/deploy-to-aks.sh --httpspg_durable is a built-in special mode — it is NOT a user-uploadable runtime image.
When adding runtime image support:
pg_durable uses special env vars and pg_hba.conf configurationimage_type = 'stock' when a runtime_image_id is provided// In toygres-server/src/api.rs
async fn my_endpoint(
State(state): State<AppState>,
Path(name): Path<String>,
) -> Result<Json<serde_json::Value>, AppError> {
// Your logic here
Ok(Json(serde_json::json!({
"success": true,
"message": "Operation completed"
})))
}
// Add route in create_router():
.route("/api/instances/:name/my-action", post(my_endpoint))
// In toygres-ui/src/lib/api.ts
async myAction(name: string): Promise<{ success: boolean; message: string }> {
const response = await this.fetch(`/api/instances/${encodeURIComponent(name)}/my-action`, {
method: 'POST',
});
if (!response.ok) {
const error = await response.json();
throw new Error(error.error || 'Action failed');
}
return response.json();
}
const myMutation = useMutation({
mutationFn: (name: string) => api.myAction(name),
onSuccess: (data) => {
queryClient.invalidateQueries({ queryKey: ['instance', name] });
showToast('success', data.message);
},
onError: (error: Error) => {
showToast('error', `Failed: ${error.message}`);
},
});
// In JSX:
<Button onClick={() => myMutation.mutate(name)} disabled={myMutation.isPending}>
{myMutation.isPending ? 'Working...' : 'Do Action'}
</Button>
Simple/Atomic (direct K8s or DB call):
Durable (multi-step, needs retry/recovery):
For adding a new "catalog" of entities (like runtime images):
See database-changes skill for detailed SQL patterns.
Deploying and debugging Toygres on AKS (Azure Kubernetes Service). Use when deploying, debugging pods, viewing logs, troubleshooting SSL, or managing Kubernetes resources.
Guidance for safely versioning Duroxide orchestrations — file structure, naming conventions, workflow, and registry registration.
Making database schema changes to the CMS database. Use when adding columns, tables, running migrations, or updating the backend API and TypeScript types for new database fields.
Writing durable workflows using Duroxide in Rust. Use when creating orchestrations, activities, workflows, or when the user mentions duroxide, durable functions, or workflow orchestration.
Implementing and debugging PostgreSQL image backup and restore features. Use when working with database snapshots, backup jobs, restore operations, azcopy blob transfers, or troubleshooting image-related provisioning failures.
Managing instance actor orchestrations for PostgreSQL health monitoring. Use when debugging stale actors, restarting actors, or troubleshooting health check issues.