skills.rest
vctplatform
vctplatformCOMMUNITY
Explore all skills by this author →
GitHub

dba

Manage PostgreSQL 18+ databases on Neon and Supabase.

Updated Aug 27, 2026
Search Tags:#postgresql#migrations#database management#supabase#neon#performance tuning#dba
One-click install
npx skills add https://github.com/vctplatform/vct-erp --skill dba
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba
Source: https://github.com/vctplatform/vct-erp/tree/main/vct-erp/.agents/skills/dba
Command: npx skills add https://github.com/vctplatform/vct-erp --skill dba

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the management and optimization of PostgreSQL databases, ensuring high performance, reliability, and security for the VCT Platform.

Core Features & Use Cases

  • Database Administration: Handles schema design, migrations, indexing, and performance tuning for PostgreSQL 18+.
  • Serverless & BaaS Integration: Manages databases on Neon (serverless) and Supabase, leveraging features like RLS and real-time capabilities.
  • Use Case: Ensure optimal database performance by analyzing slow queries, implementing appropriate indexes, and configuring Neon's autoscaling for fluctuating workloads.

Quick Start

Use the dba skill to analyze the performance of the 'athletes' table and suggest indexing improvements.

Frequently Asked Questions about dba

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I manage PostgreSQL migrations and schema design on Neon serverless?▼

Optimize slow PostgreSQL queries by analyzing execution plans, implementing appropriate indexes, and configuring Neon's autoscaling for fluctuating workloads. This maintains high database performance and reliability under variable traffic loads.

Does this approach support incremental backups and disaster recovery for Supabase?▼

Yes, incremental backups and disaster recovery are supported for Supabase databases. Configure incremental backup strategies to securely restore data while maintaining Row Level Security policies for protected access control.

What is the best way to tune PostgreSQL 18+ performance for high traffic applications?▼

Tune PostgreSQL 18+ performance by analyzing slow queries, implementing appropriate indexes, and configuring database autoscaling. This targets high traffic application bottlenecks to ensure optimal performance and reliability.

Can I use PostgreSQL advanced features like JSON_TABLE and virtual columns with Supabase?▼

Yes, PostgreSQL advanced features like JSON_TABLE and virtual columns are fully supported with Supabase. Utilize these features to handle complex data structures while maintaining real-time capabilities and Row Level Security.

When do I need to configure Neon autoscaling for PostgreSQL databases?▼

Configure Neon autoscaling for PostgreSQL databases when experiencing fluctuating workloads. Autoscaling dynamically adjusts compute resources to ensure high performance during traffic spikes without over-provisioning serverless infrastructure.

Related Skills

Explore More Software Engineering Skills→
BAIZ1DBAIZ1D

base

Automate LibreOffice Base database creation, management, and data operations.

Community
Intermediate
VXerysVXerys

database-optimizer

Analyze slow PostgreSQL and MySQL queries and generate index strategies.

Community
Advanced
haJ1thaJ1t

supabase-pro

Integrate Supabase authentication, real-time subscriptions, RLS policies, storage, and Edge Functions.

Community
Advanced
windyskywindysky

moai-platform-neon

Manage Neon serverless PostgreSQL deployments with branching, PITR, and connection pooling.

Community
Advanced