Planning Center Services SQL Queries

Access comprehensive worship planning and volunteer management data from Planning Center Services through Parable's unified SQL interface.

Data Model

Explore all 63 Services tables with complete field documentation

Basic Queries

Simple queries for common worship and volunteer questions

Advanced Analytics

Sophisticated analysis for scheduling optimization and trends

Reporting Examples

Production-ready queries for dashboards and reports

What's Available

Planning Center Services data in Parable provides complete access to your worship planning and volunteer management system.

📊 Core Capabilities

Service Planning - Access all service plans, series, and scheduling data
Volunteer Management - Track team participation, availability, and engagement
Song Analytics - Monitor song usage, keys, themes, and rotation patterns
Team Health - Analyze team capacity, confirmation rates, and scheduling gaps
Resource Tracking - Manage attachments, chord charts, and media files
Multi-Site Coordination - Synchronize services across campuses

🎯 Key Use Cases

Volunteer Scheduling & Management

Track volunteer participation and availability
Identify scheduling conflicts and gaps
Monitor team health and prevent burnout
Analyze confirmation and decline patterns
Coordinate blockout dates and preferences

Worship Planning & Song Selection

Analyze song usage and rotation patterns
Track key preferences and arrangements
Monitor theme combinations and flow
Manage CCLI reporting and copyright
Optimize service length and composition

Team Development & Growth

Assess team capacity and coverage
Identify training needs and gaps
Track background check compliance
Monitor team engagement levels
Plan recruitment strategies

Service Effectiveness

Analyze service timing and flow
Track item types and distributions
Monitor volunteer-to-task ratios
Measure preparation timelines
Evaluate multi-service consistency

Quick Start Examples

Who's Serving This Sunday?

SELECT
    p.full_name,
    t.name as team,
    pp.team_position_name as role,
    pl.title as service,
    pp.status
FROM planning_center.services_plan_people pp
JOIN planning_center.services_people p ON pp.person_id = p.person_id
JOIN planning_center.services_teams t ON pp.team_id = t.team_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE
    AND pl.sort_date < CURRENT_DATE + INTERVAL '7 days'
ORDER BY pl.sort_date, t.name;

Top Songs This Quarter

SELECT
    s.title,
    s.author,
    COUNT(DISTINCT i.plan_id) as times_used,
    MAX(pl.sort_date) as last_used
FROM planning_center.services_songs s
JOIN planning_center.services_items i ON s.song_id = i.song_id
JOIN planning_center.services_plans pl ON i.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE - INTERVAL '3 months'
    AND i.item_type = 'song'
GROUP BY s.song_id, s.title, s.author
ORDER BY times_used DESC
LIMIT 20;

Volunteer Activity Summary

SELECT
    t.name as team,
    COUNT(DISTINCT pp.person_id) as volunteers,
    COUNT(CASE WHEN pp.status = 'C' THEN 1 END) as confirmed,
    COUNT(CASE WHEN pp.status = 'D' THEN 1 END) as declined,
    ROUND(AVG(CASE WHEN pp.status = 'C' THEN 100.0 ELSE 0 END), 1) as confirm_rate
FROM planning_center.services_plan_people pp
JOIN planning_center.services_teams t ON pp.team_id = t.team_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY t.name
ORDER BY volunteers DESC;