01-Product / 01.10.RDB-Features01.10.RDB Features
01.10. RDB Features
This document outlines the core features and functionalities of the bnc-cpt-rdb (Relational Database) project.
Database Management & Operations
- CloudSQL Administration: Automated tools for listing and managing GCP CloudSQL instances across environments.
- Data Ingestion: High-speed import of SQL or binary database dumps from Google Cloud Storage (GCS) to CloudSQL.
- Remote Connectivity: Automated setup of secure SSH tunnels for remote database access, including pre-configured connections for PHP Adminer.
Data Synchronization & Backups
- GCS Synchronization: Robust utilities for syncing data between the local filesystem and GCS buckets.
- Cross-Region/Bucket Sync: Tools for replicating data between different GCS source and target buckets.
- Automated Cleanup: Policy-based removal of aged GCS files to manage backup storage costs.
Infrastructure Automation
- Project Orchestration: Creation and deletion of GCP projects specifically tailored for database workloads.
- Resource Provisioning: Management of Secret Manager secrets, GCS buckets, and DNS record exports.
- Serverless Integration: Deployment of Cloud Functions and execution of Cloud Build triggers related to database tasks.
Project & Git Replication
- Codebase Replication: Sophisticated tools for replicating full projects, specific directories, or individual files from a source to a target.
- Git State Sync: Automated replication of git changes across related repositories.
- Bulk Repository Management: Unified commands to pull or push all application-related repositories.
Credential & Workflow Management
- Secure Secret Access: Integration with KeePassXC (
.kdbx) for secure retrieval of database credentials and other secrets.
- CI/CD Integration: Direct triggering of GitHub Actions workflows from the command line.
- Secret Manager to Env: Exporting GCP Secret Manager secrets directly into
.env files for application use.