Sprint Planner Pro: Streamlit-powered agile sprint management tool. Simplifies planning, tracking, and analytics with SQLite. AI assistant enables natural language queries for tasks, capacity, and insights, boosting team collaboration.
Overview
Sprint Planner Pro is an intuitive, web-based application built with Streamlit for managing agile sprints in software development teams. Designed to streamline workflow, enhance collaboration, and provide actionable insights, this tool helps teams plan, track, and analyze their sprints efficiently. It integrates with SQLite for data persistence and includes an AI-powered assistant for natural language queries on sprint data.
Purpose
The primary goal of Sprint Planner Pro is to simplify agile project management by centralizing sprint-related activities. Whether you're a scrum master, product owner, or team member, it reduces administrative overhead, improves visibility into progress, and facilitates data-driven decisions. It's particularly useful for distributed teams working with tools like Azure DevOps, as it fetches work item details seamlessly.
Key Features
- Sprint Management: Create and manage sprints with start/end dates, goals, and backlogs.
- Team and Member Management: Organize teams, add members with roles (e.g., Developer, Tester), and view team overviews.
- Capacity Planning: Calculate team capacity considering holidays, leaves, and maximum hours.
- Work Item Tracking: Import and manage work items from Azure DevOps, including story points, status, and demo requirements.
- Retrospective Tools: Capture what went well, areas for improvement, action plans, and track their status.
- Demo Tracking: Log demo details like impact, approvers, and feedback for work items marked for demonstration.
- Analytics Dashboard: Visualize burn-down charts, completion rates, status distributions, and efficiency metrics.
- AI Assistant: A chatbot powered by LangChain and Groq LLM for querying and modifying sprint data via natural language (e.g., "Add a new task" or "What's the team's capacity?").
- Admin Panel: Securely create sprints, teams, and members.
- Custom Styling: Responsive UI with custom CSS, background images, and intuitive navigation.
This project is open-source and extensible, making it ideal for customization to fit specific team needs.
Installation and Setup
- Python 3.8 or higher
- Git
- An Azure DevOps Personal Access Token (PAT) for work item integration (optional but recommended)
Step-by-Step Installation
- Clone the Repository:
- git clone https://github.com/CodeHub5199/Sprint-Planner-Pro.git
- cd Sprint-Planner-Pro
- Create a Virtual Environment (recommended):
- python -m venv venv
- source venv/bin/activate # On Windows: venv\Scripts\activate
- Install Dependencies:
- pip install -r requirements.txt
- Database Setup:
- The app uses a SQLite database (sprint_management.db). No manual setup is needed; it will be created/used automatically. If you have sample data, import it via SQL scripts.
Configuration:
- In team.py, update the Azure DevOps organization, projects, and PAT in the get_work_item function.
- Add images to the images/ directory (e.g., home_background12.jpg, adient_logo.png).
- Set the Groq API key in home.py for the AI assistant.
Run the Application:
- streamlit run home.py
- Access the app at http://localhost:8501.
Troubleshooting
If Streamlit fails to start, ensure port 8501 is free. For AI features, verify your Groq API key is valid. Database issues: Check write permissions for the directory containing sprint_management.db
Usage Guidelines
Getting Started
Launch the app and select a team from the home page. Use the sidebar for navigation: Demo Dashboard, Team Members, Admin Panel, or AI Assistant.
Examples
Creating a Sprint (Admin Panel):
- Navigate to Admin > Create New Sprint.
- Enter dates and click "Create Sprint".
- Example: Start a sprint from 2025-09-01 to 2025-09-15.
Adding Work Items (Team Page > Sprint Backlog):
Select a sprint and team. Enter Azure DevOps Work ID (e.g., 12345) and add details like story points and assignee. The app fetches the work item title and type automatically.
Capacity Planning:
- On the team page, edit member capacities, holidays, and leaves.
- Save to update actual capacity calculations.
Using the AI Assistant:
- Click "AI Assistant" in the sidebar.
- Query: "Show tasks for Sprint 1" or "Update task status to Completed".
- Supports read/write operations with safety checks.
Viewing Analytics:
- On the team page > Sprint Analytics tab.
- See burn-down charts, metrics like completion rate, and visualizations.