CEAR Internal

The challenge

A team of two to five people was juggling ideas, client projects and tasks across chats and spreadsheets. They needed one place for all of it, fast enough to use every day, and cheap enough to run entirely on free plans.

What I built

A full-stack app with Astro on the server, React for the interactive views and a Postgres database on Neon, deployed on Vercel.

• From idea to delivered project. Ideas are written down, evaluated and, once approved, turned into a project with client, folder, due date and progress.
• Three ways to see the work. Tasks show as a grouped list, a Kanban board where dragging saves status and order, or a calendar where dragging a task to another day changes its due date.
• Details without leaving the page. Each task opens in a side panel with subtasks, comments and @ mentions, and its link can be shared.
• A home page that says what’s next. Your open tasks, the week in numbers, active projects, recent ideas and the latest comments.
• Built for the keyboard. Search everything with Ctrl/⌘ K, N for a new task, ⇧N for a new idea and ⇧T to switch between light and dark.
• The boring parts done right. Email and GitHub sign-in with roles, invitations, notifications, a daily email digest and an optional “Improve with AI” button that rewrites descriptions with Claude, ChatGPT or Gemini.