KDevs

Showing 25 of 43 from the live probe.

• List Tables

  Lists all accessible tables in the connected database, grouped by schema.

• List Extensions

  Lists all installed PostgreSQL extensions in the database.

• List Migrations

  Lists applied database migrations recorded in supabase_migrations.schema_migrations table.

• Apply Migration

  Applies a SQL migration script and records it in the supabase_migrations.schema_migrations table within a transaction.

• Execute Sql

  Executes an arbitrary SQL query against the database. SECURITY: Requires service_role key or direct database connection.

• Get Database Connections

  Retrieves information about active database connections from pg_stat_activity.

• Get Database Stats

  Retrieves statistics about database activity and the background writer from pg_stat_database and pg_stat_bgwriter.

• Get Project Url

  Returns the configured Supabase project URL for this server.

• Generate Typescript Types

  Generates TypeScript types from the database schema using the Supabase CLI (`supabase gen types`) and downloads the file to the specified absolute path. The tool returns the current platform (win32, darwin, linux) to help with path formatting. Requires DATABASE_URL configuration and Supabase CLI installed.

• Rebuild Hooks

  Attempts to restart the pg_net worker. Requires the pg_net extension to be installed and available.

• Verify Jwt Secret

  Checks if the Supabase JWT secret is configured for this server.

• List Auth Users

  Lists users from the auth.users table.

• Get Auth User

  Retrieves details for a specific user from auth.users by their ID.

• Delete Auth User

  Deletes a user from auth.users by their ID. Requires service_role key and direct DB connection.

• Create Auth User

  Creates a new user directly in auth.users. WARNING: Requires plain password, insecure. Use with extreme caution.

• Update Auth User

  Updates fields for a user in auth.users. WARNING: Password handling is insecure. Requires service_role key and direct DB connection.

• List Storage Buckets

  Lists all storage buckets in the project.

• List Storage Objects

  Lists objects within a specific storage bucket, optionally filtering by prefix.

• List Realtime Publications

  Lists PostgreSQL publications, often used by Supabase Realtime.

• List Cron Jobs

  Lists all scheduled cron jobs from pg_cron extension. Returns empty array if pg_cron is not installed.

• List Vector Indexes

  Lists all pgvector indexes (ivfflat, hnsw) in the database. Returns empty array if pgvector is not installed or no vector indexes exist.

• List Edge Functions

  Lists all deployed Supabase Edge Functions. Returns empty array if edge functions are not available or none are deployed.

• Get Edge Function Details

  Gets detailed information about a specific Supabase Edge Function by ID or slug. Returns null if not found or edge functions are not available.

• Get Logs

  Gets logs for a Supabase service. Attempts to query the analytics stack first, then falls back to PostgreSQL CSV logs. Returns logs from the last 24 hours. Note: Log availability depends on your self-hosted installation configuration.

• Get Advisors

  Gets security or performance advisory notices for the database. Based on Supabase Splinter linting rules. Helps identify issues like missing RLS policies, unindexed foreign keys, and other common problems.