skills.rest
snake14v
snake14vCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

DB-Surveyor

Inspect PostgreSQL and MySQL schemas and analyze query plans with EXPLAIN ANALYZE.

Updated Mar 7, 2026
Search Tags:#indexing#database#postgresql#mysql#query-optimization#explain-analyze#schema-inspection
One-click install
npx skills add https://github.com/snake14v/antigravity-web-swarm --skill db-surveyor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: DB-Surveyor
Source: https://github.com/snake14v/antigravity-web-swarm/tree/main/.agent/skills/db-surveyor
Command: npx skills add https://github.com/snake14v/antigravity-web-swarm --skill db-surveyor

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Facilitates safe, autonomous database inspection for PostgreSQL and MySQL environments. Backend agents can view schemas, run EXPLAIN ANALYZE on complex queries, and suggest index optimizations without modifying production data.

Core Features & Use Cases

  • Schema inspection: discover tables, relationships, and constraints in development or staging.
  • Query analysis: run EXPLAIN ANALYZE plans and surface slow queries with recommendations.
  • Safe optimization: propose index and schema changes with rollback-friendly guidance.

Quick Start

Run a safe analysis of your development database to surface schema insights and optimization suggestions.

Frequently Asked Questions about DB-Surveyor

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

FAQPage Schema
How do I run a safe database schema inspection on a PostgreSQL or MySQL database?▼

Database schema inspection discovers tables, relationships, and constraints in PostgreSQL or MySQL environments without modifying production data, autonomously surfacing schema insights for development, staging, or safe production-refresher workflows.

How do I use EXPLAIN ANALYZE to surface slow query plans for optimization?▼

Running EXPLAIN ANALYZE evaluates complex query plans to surface slow queries and provide index optimization recommendations, operating safely without data modification during backend agent analysis.

Can I propose index and schema changes on a production database without data modification?▼

You can propose index and schema changes on production databases without data modification by generating rollback-friendly guidance and index recommendations for implementation via schema changes or ORM tooling.

Does this autonomous query optimization approach work with both PostgreSQL and MySQL?▼

This autonomous query optimization approach works with both PostgreSQL and MySQL environments, detecting the environment automatically to safely run schema discovery, EXPLAIN ANALYZE, and index recommendations.

What is the best way to suggest index improvements without directly altering the database?▼

The best way to suggest index improvements without altering the database is to run autonomous, safe analysis that proposes rollback-friendly schema and index changes for implementation via ORM tooling.

Related Skills

Explore More Data & Analytics Skills→
SSujitXSSujitX
11

Managed Databases

Provision and manage containerized database instances in Docker environments.

Community
Advanced
linenoizelinenoize
1

db

Generate rollback-aware database migration files and validate schema changes.

Community
Advanced
StrategicMilkStrategicMilk

Database Schema Analysis

Analyze SQLite, PostgreSQL, or ORM schemas and output a JSON report.

Community
Intermediate
shalevaminshalevamin

database-optimizer

Analyze execution plans and optimize PostgreSQL and MySQL database performance.

Community
Advanced