Enforce consistent UTC handling across code, databases, and APIs.
npx skills add https://github.com/git-tao/taotang-website --skill timezone-safety
Please help me install this Agent Skill. Skill: timezone-safety Source: https://github.com/git-tao/taotang-website/tree/main/.claude/skills/timezone-safety Command: npx skills add https://github.com/git-tao/taotang-website --skill timezone-safety
This skill prevents timezone-related bugs by enforcing consistent UTC handling across code, databases, and APIs.
Start by auditing date/time usage in your project and adopt UTC-first conventions for new code.
High-intent search queries and answers about installing and using this skill.
To handle UTC timestamps across databases, APIs, and frontends, enforce consistent UTC usage internally, use TIMESTAMPTZ for database storage, and apply ISO 8601 with Z for API responses to prevent drift.
The best way to format datetime in API responses is using ISO 8601 with the Z suffix. This enforces consistent UTC handling for data transfer and prevents timezone discrepancies across multi-region applications.
Timezone discrepancies happen when internal timestamps are not stored or communicated in UTC. Mixing local times with database timestamps without TIMESTAMPTZ causes drift and misinterpretation across different regions.
To convert UTC timestamps for UI display without offset errors, maintain UTC usage internally and perform safe comparisons by converting times to the user's local timezone only at the frontend rendering stage.
Yes, you need TIMESTAMPTZ in your database even if your backend uses UTC. TIMESTAMPTZ ensures the database properly recognizes and stores timezone-aware timestamps, preventing data misinterpretation during queries.
You should audit date and time usage before adopting UTC-first conventions for new code. Auditing existing datetime usage identifies local time dependencies and ensures safe comparisons across backend and frontend workflows.
mjunaidcaConvert browser local datetimes to UTC for API submission and back for display.
eatbreadsSummarize Lark calendar events and unfinished tasks into standup reports.
musher-devEnforce RFC 3339 timestamps, ISO 8601 durations, and snake_case field naming in API payloads.
dangdungvnConfigure Flutter apps for multi-language support using intl and ARB files.
