Redshift Tools

Execute SQL statements on Redshift database. Supports all SQL operations including COPY and UNLOAD.

Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, and Redshift distribution i...

Get Redshift-specific table design information including distribution key, sort keys, and column encoding. Essential for query optimization.

Profile a column's data distribution: min, max, distinct count, null percentage, and most frequent values.

List Redshift tables with filtering and metadata options. Includes Redshift-specific information like distribution keys and sort keys.

Analyze data distribution across Redshift slices to identify skew. Shows how evenly data is distributed, which affects query performance.

Inspect Redshift schema or table in detail. Get comprehensive information about tables, columns, distribution, and sort keys.

Browse rows from a Redshift table with filtering, column selection, sorting, and pagination.

Search Redshift database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Maximum 100 results per search.

Universal fetch tool that retrieves any row, table schema, or metadata using smart ID routing.