Streamline Your HR Operations with a SQLite Based HR Management System
•AI

Streamline Your HR Operations with a SQLite Based HR Management System

By Administrator
课程Vibe Coding & Tech Startup 创业课程结合 AI 辅助编程与创业思维：从灵感到原型、迭代到上线，一步步把想法做成可用的产品。前往课程页查看完整大纲、上课方式与报名／咨询渠道。查看课程大纲与详情 →

For Small and Medium Enterprises (SMEs) in Hong Kong, managing sensitive employee data while balancing operational efficiency can be a challenge. If you are looking for a privacy-first, lightweight solution, building a SQLite based HR management system is a highly effective approach.

Today, we are introducing HKHR-Skills, a modular, agent-ready toolkit designed to turn SQLite into a powerful engine for HR operations.

Why Choose a SQLite-Based Approach?

By leveraging SQLite as your database backend, you gain several advantages:

  • Data Sovereignty: All employee records, salary data, and tax information stay on your local machine or server.
  • Low Overhead: No complex database server setup required.
  • AI-Ready: The system is designed for modern AI agents (like Claude Code or Cursor) to interact with your data via JSON-based outputs.

Core Modules of the HKHR-Skills Toolkit

This system is built with modularity in mind, covering the most critical aspects of SME HR management:

1. Employee Master (EMPLOYEE)

Maintain a centralized record of your workforce. The system supports full CRUD operations, ensuring you can manage contact info, job titles, and employment status with ease.

2. Lifecycle & Compliance (LIFECYCLE & COMPLIANCE)

Automate your HR burden. Use predefined templates for onboarding and offboarding to ensure no security access or equipment return is missed. Track compliance records, including work eligibility and contract renewals.

3. Leave Management (LEAVE)

Align your operations with standard leave structures. Handle pending, approved, and rejected requests, and manage compensation leave efficiently.

4. Financial Processing (ADW & IR56B)

This is where the system truly shines for HK-based businesses:

  • ADW (Average Daily Wage): Process payroll from various Excel formats with intelligent schema inference.
  • IR56B Preparation: Automatically check the readiness of your tax filing data and export clean workbooks for the Inland Revenue Department.

Getting Started

Installation

  1. Prerequisites: Ensure you have Python 3.10+ installed.
  2. Setup: Clone the repository and install the dependencies:
    python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
  3. Initialize: Run the initialization script to set up your local hrcore.db file:
    python scripts/init_employee.py

The AI-First Workflow

This system is optimized for AI-assisted HR ops. By using command-line scripts that output structured JSON, you can ask your preferred AI assistant to:

  • "Add a new employee and set their onboarding tasks."
  • "Run an IR56B readiness check and list missing fields."
  • "Calculate the monthly ADW payout and flag any anomalies."

Security and Privacy Notice

Because you are dealing with PII (Personally Identifiable Information), please remember to:

  • Keep your hrcore.db file in a secure, encrypted directory.
  • Use local models if you want to avoid sending sensitive HR data to third-party cloud LLMs.
  • Regularly back up your database file.

Ready to get started? Visit the HKHR-Skills GitHub repository to explore the schemas and start your journey toward a more automated, local-first HR system.