PostgreSQL Read Only Query Skill
Skill Verifiziert AktivExecute read-only SQL queries against multiple PostgreSQL databases. Use when: (1) querying PostgreSQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
To provide a safe and convenient way to query PostgreSQL databases for data analysis and schema exploration without the risk of accidental data modification.
Funktionen
- Execute read-only SQL queries
- Connect to multiple PostgreSQL databases
- Intelligent database auto-selection via descriptions
- Block all write operations
- Query and schema introspection
Anwendungsfälle
- Querying PostgreSQL databases for data analysis.
- Exploring database schemas and table structures.
- Checking and retrieving specific database contents.
- Safely accessing read-only data from production databases.
Nicht-Ziele
- Performing any write operations (INSERT, UPDATE, DELETE, DROP).
- Executing multi-statement SQL queries.
- Connecting to databases other than PostgreSQL.
Workflow
- List available PostgreSQL databases
- Match user intent to a database description
- Explore database structure using `--tables` or `--schema`
- Execute a read-only query with optional `--limit`
Praktiken
- Data Querying
- Database Security
- Read-Only Operations
Voraussetzungen
- Python 3.8+
- psycopg2-binary (install via pip)
Execution
- info:Pinned dependenciesWhile dependencies are declared (`requirements.txt` implied, `psycopg2-binary` mentioned), explicit pinning via a lockfile is not evident.
Installation
Zuerst Marketplace hinzufügen
/plugin marketplace add sanjay3290/ai-skills/plugin install ai-skills@ai-skillsQualitätspunktzahl
VerifiziertVertrauenssignale
Ähnliche Erweiterungen
DBHub Database Query Guide
100Anleitung zum Abfragen von Datenbanken über den DBHub MCP-Server. Verwenden Sie diese Fähigkeit immer dann, wenn Sie Datenbankschemata untersuchen, Tabellen inspizieren oder SQL-Abfragen über die MCP-Tools von DBHub ausführen müssen (search_objects, execute_sql). Aktiviert bei jeder Datenbankabfrageaufgabe, Schemadeckung, Datenabfrage oder SQL-Ausführung über MCP – auch wenn der Benutzer nur „Datenbank prüfen“ oder „mir Daten finden“ sagt. Diese Fähigkeit stellt sicher, dass Sie dem richtigen Workflow „zuerst erkunden“ folgen, anstatt Tabellenstrukturen zu erraten.
Dsql
100Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.
MySQL Read Only Query Skill
99Execute read-only SQL queries against multiple MySQL databases. Use when: (1) querying MySQL databases, (2) exploring database schemas/tables, (3) running SELECT queries for data analysis, (4) checking database contents. Supports multiple database connections with descriptions for intelligent auto-selection. Blocks all write operations (INSERT, UPDATE, DELETE, DROP, etc.) for safety.
Migrate Validate
100Validate pending migrations for foreign key consistency, rollback safety, and best practices
Azure Postgres Ts
100Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package. Use for PostgreSQL queries, connection pooling, transactions, and Microsoft Entra ID (passwordless) authentication. Triggers: "PostgreSQL", "postgres", "pg client", "node-postgres", "Azure PostgreSQL connection", "PostgreSQL TypeScript", "pg Pool", "passwordless postgres".
Sql Optimization
100Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.