Asana API
Track project velocity, task completion, and team workload
Pull projects, tasks, and assignees from the Asana API. Monitor completion rates, identify bottlenecks, and track how work distribution changes over time.
Free plan includes API access. Rate limited to 1,500 requests/minute.
How it works with Loony
Describe it.
Deploy it.
Query it.
Managed database.
Your Asana data lives in its own Postgres instance. Zero config. Data accumulates over time.
Scheduled syncs.
Cron jobs run on Loony infra. Hourly on free. Your data stays fresh without you thinking about it.
REST + MCP endpoints.
Query from your agent, your dashboard, or connect BI tools directly. Full OpenAPI spec included.
$ "Pull all Asana tasks from the last 90 days with project, assignee, due date, completion status, and tags. Build weekly completion rates by project and assignee." ✓ Schema validated ✓ Database provisioned ✓ Scripts deployed ✓ Schedules registered Done. # Your data is now at: REST /data/v1/asana/query MCP /mcp/v1/asana/mcp SQL psql $DATABASE_URL
What you get
Asana shows you task lists but makes it hard to see trends. Loony syncs your projects and tasks into Postgres on a schedule so your agent can answer 'Which team member has the most overdue tasks this sprint?' or 'How has our completion rate changed over the last quarter?'
mv_weekly_velocity week date -- ISO week start project text -- project name assignee text -- team member tasks_created integer -- new tasks tasks_completed integer -- completed tasks overdue integer -- past due date completion_rate numeric -- completed / total
Even better together
Join Asana project data with Jira or Linear to get a unified view across engineering and cross-functional work. Add Slack to correlate task completion with team communication patterns.