Councillor’s Workspace
Bringing documents, local news, email and calendar together to help prepare for council work.

Problem
Preparing for council work means gathering documents and understanding how they relate to local news, correspondence and upcoming meetings.
Solution
The workspace brings these materials together, with summaries, key passages, related news coverage and extracts from legislation. A daily Pruszków news digest and email and calendar integrations are already working.
My contribution
Designing and developing the tool for my own use, then preparing a version for other councillors.
Built for my own council work
I built the workspace to help me navigate council documents, spot connections and get an initial understanding of an issue before examining it in more depth.
Project status
I use the tool myself and have prepared a version for other councillors. The next step is a pilot with a small group; it has not yet been rolled out to other users.
Technology
The backend is Python and FastAPI, with data in SQLite, Alembic migrations (SQLAlchemy) and scheduled jobs in APScheduler. PDF, DOCX, XLSX and HTML documents are converted to text, and news sources are collected from RSS feeds and web pages. The interface is built with React, TypeScript and Tailwind CSS. Summaries come from a language model behind a replaceable provider layer.
The role of AI
Early on, I compared the AI’s output with source documents and refined what it should highlight. I now use the context, quotations and legislative extracts to get an initial overview. I do not systematically check every output against its source.
AI can make mistakes. The workspace helps with preparation and an initial overview; its output is not presented as verified legal analysis.
Technologies
Python, FastAPI, SQLite, React, TypeScript, Tailwind CSS, LLM, Gmail and Google Calendar
Last updated: