Schema Documentation Generator
Read database schema, generate structured documentation, and save it to Google Drive
Example Prompt
Generate documentation for our Postgres database schema and save it to Google Drive
About
This skill connects to your database, introspects the full schema including tables, columns, types, and relationships, then produces clear and structured documentation. The finished document is uploaded to Google Drive so the team always has an up-to-date reference for the data model.
Workflow Steps
Query the database information schema to retrieve all tables, columns, types, and constraints
📊 Run SQL QueryQuery foreign key relationships and indexes to map table dependencies
📊 Run SQL QueryReason through the schema to organize tables into logical groups and write clear descriptions
🧠 Structured ReasoningWrite the generated documentation to a local file
✏️ Write FileSearch Google Drive for the existing schema doc to determine where to upload the update
📂 Search DriveTools Used
Write File
Write or overwrite a file at a specified path with the given content
Search Drive
Search Google Drive for files and folders by name, type, or content
Run SQL Query
Execute a read-only SQL query against a PostgreSQL database and return results
Structured Reasoning
Break down a complex problem into sequential reasoning steps with explicit chain-of-thought
Required MCP Servers
Filesystem
Read, search, and manage files on the local filesystem
Google Drive
Search, read, and manage files in Google Drive including Docs, Sheets, and Slides
PostgreSQL
Query, inspect, and manage PostgreSQL databases with full SQL support
Sequential Thinking
Dynamic problem-solving through structured thought sequences with branching and revision