Edit

Copilot tools reference

This page lists all language model tools registered by the PostgreSQL extension for use with GitHub Copilot. Generated from package.json (16 tools).

Tool Name Description Tags
pgsql_bulk_load_csv Bulk Load CSV Bulk load CSV data into a PostgreSQL table. postgres, csv, bulk-load
pgsql_connect Connect to PostgreSQL Database Connect to a PostgreSQL server. databases, postgresql, pgsql
pgsql_db_context Get Database Objects Use this tool to fetch the current database schema context for all object types. Always run this before any queries or modifications. databases, postgresql, pgsql
pgsql_describe_csv Describe CSV File Describe a CSV file and return its schema as YAML. csv, frictionless, import, data
pgsql_disconnect Disconnect from PostgreSQL Database Disconnect from a PostgreSQL server. databases, postgresql, pgsql
pgsql_get_dashboard_context Get Dashboard Context Get high-level dashboard context and discover available metrics before fetching data. metrics, monitoring, performance, postgresql, pgsql
pgsql_get_dashboard_metric_data Get Dashboard Metric Data Fetch cached time-series data from the Server Dashboard for selected metrics. metrics, monitoring, performance, postgresql, pgsql
pgsql_list_connection_profiles List Connection Profiles List all connection profiles registered with the PGSQL extension. databases, postgresql, pgsql
pgsql_list_databases List Databases List all databases on the PostgreSQL server for the current connection. Use this to discover available databases. databases, postgresql, pgsql
pgsql_migration_oracle_app Oracle Client Code Application Converter A tool that converts Oracle client application code to PostgreSQL equivalents using sophisticated prompt templates and coding guidance from migration analysis.
pgsql_migration_show_report Show Oracle to Postgres Migration Report A tool that shows the Oracle Migration reports generated by the Oracle to Postgres Converter.
pgsql_modify Modify Database Modify a connected database by executing a SQL statement. databases, postgresql, pgsql, schema, ddl, migrations
pgsql_open_script Open SQL Script Open an new SQL script editor with script content generated by agents. databases, postgresql, pgsql, script, batch
pgsql_query Run a Query Run a SQL query on a connected database. databases, postgresql, pgsql
pgsql_query_plan Query Plan Inspect a cached PostgreSQL query execution plan. Use this tool when the user asks about query performance and a planId is available. Supports actions: get_summary (plan overview with key metrics and notable nodes), get_node (detailed info for a specific node by ID), get_subtree (a node and its descendants to specified depth), list_nodes (filter nodes by type or minimum cost). Always start with get_summary to understand the plan structure before drilling into specific nodes. databases, postgresql, pgsql, query, performance, explain
pgsql_visualize_schema Visualize Database Schema Visualize the schema for a connected PostgreSQL database. databases, postgresql, pgsql, schema, visualization