Connection check
local install
neverinfamous-postgres-mcp
PostgreSQL MCP server with 203 tools, connection pooling, HTTP/SSE, OAuth 2.1, and tool filtering
Tools
266
GitHub stars
—
Installs / wk
145
Licence
—
Transport
stdio
Last checked
never
Tools & capabilities
266 toolsRead from the published package source — this server runs locally, so there is no endpoint to query. Names are taken from the code, not observed at runtime, and descriptions are often absent.
pg_alert_threshold_set
from source
pg_analyze
from source
pg_analyze_db_health
from source
pg_analyze_query_indexes
from source
pg_analyze_workload_indexes
from source
pg_append_insight
from source
pg_attach_partition
from source
pg_audit_diff_backup
from source
pg_audit_list_backups
from source
pg_audit_restore_backup
from source
pg_backup_physical
from source
pg_backup_schedule_optimize
from source
pg_batch_insert
from source
pg_bloat_check
from source
pg_bounding_box
from source
pg_buffer
from source
pg_cache_hit_ratio
from source
pg_cancel_backend
from source
pg_capacity_planning
from source
pg_cascade_simulator
from source
pg_citext_analyze_candidates
from source
pg_citext_compare
from source
pg_citext_create_extension
from source
pg_citext_list_columns
from source
pg_citext_schema_advisor
from source
pg_cluster
from source
pg_connection_pool_optimize
from source
pg_connection_stats
from source
pg_constraint_analysis
from source
pg_copy_export
from source
pg_copy_import
from source
pg_count
from source
pg_create_backup_plan
from source
pg_create_fts_index
from source
pg_create_index
from source
pg_create_partition
from source
pg_create_partitioned_table
from source
pg_create_schema
from source
pg_create_sequence
from source
pg_create_table
from source
pg_create_view
from source
pg_cron_alter_job
from source
pg_cron_cleanup_history
from source
pg_cron_create_extension
from source
pg_cron_job_run_details
from source
pg_cron_list_jobs
from source
pg_cron_schedule_in_database
from source
pg_cron_unschedule
from source
pg_database_size
from source
pg_dependency_graph
from source
pg_describe_table
from source
pg_detach_partition
from source
pg_detect_bloat_risk
from source
pg_detect_query_anomalies
from source
pg_distance
from source
pg_doc_add
from source
pg_doc_collection_info
from source
pg_doc_create_collection
from source
pg_doc_create_index
from source
pg_doc_drop_collection
from source
pg_doc_find
from source
pg_doc_list_collections
from source
pg_doc_modify
from source
pg_doc_remove
from source
pg_drop_index
from source
pg_drop_schema
from source
pg_drop_sequence
from source
pg_drop_table
from source
pg_drop_view
from source
pg_dump_schema
from source
pg_dump_table
from source
pg_duplicate_indexes
from source
pg_exists
from source
pg_explain
from source
pg_explain_analyze
from source
pg_explain_buffers
from source
pg_fuzzy_match
from source
pg_geo_cluster
from source
pg_geocode
from source
pg_geo_index_optimize
from source
pg_geometry_buffer
from source
pg_geometry_column
from source
pg_geometry_intersection
from source
pg_geometry_transform
from source
pg_geo_transform
from source
pg_get_indexes
from source
pg_hybrid_search
from source
pg_index_recommendations
from source
pg_index_stats
from source
pg_intersection
from source
pg_jsonb_agg
from source
pg_jsonb_array
from source
pg_jsonb_contains
from source
pg_jsonb_delete
from source
pg_jsonb_diff
from source
pg_jsonb_extract
from source
pg_jsonb_index_suggest
from source
pg_jsonb_insert
from source
pg_jsonb_keys
from source
pg_jsonb_merge
from source
pg_jsonb_normalize
from source
pg_jsonb_object
from source
pg_jsonb_path_query
from source
pg_jsonb_pretty
from source
pg_jsonb_security_scan
from source
pg_jsonb_set
from source
pg_jsonb_stats
from source
pg_jsonb_strip_nulls
from source
pg_jsonb_typeof
from source
pg_jsonb_validate_path
from source
pg_kcache_create_extension
from source
pg_kcache_database_stats
from source
pg_kcache_reset
from source
pg_kcache_resource_analysis
from source
pg_kcache_top_cpu
from source
pg_kcache_top_io
from source
pg_like_search
from source
pg_list_constraints
from source
pg_list_extensions
from source
pg_list_partitions
from source
pg_list_schemas
from source
pg_list_sequences
from source
pg_list_tables
from source
pg_list_triggers
from source
pg_list_views
from source
pg_locks
from source
pg_ltree_convert_column
from source
pg_ltree_create_extension
from source
pg_ltree_create_index
from source
pg_ltree_lca
from source
pg_ltree_list_columns
from source
pg_ltree_match
from source
pg_ltree_query
from source
pg_ltree_subpath
from source
pg_migration_history
from source
pg_migration_init
from source
pg_migration_risks
from source
pg_migration_rollback
from source
pg_migration_status
from source
pg_object_details
from source
pg_partition_info
from source
pg_partition_strategy_suggest
from source
pg_partman_analyze_partition_health
from source
pg_partman_check_default
from source
pg_partman_create_extension
from source
pg_partman_partition_data
from source
pg_partman_run_maintenance
from source
pg_partman_set_retention
from source
pg_partman_show_config
from source
pg_partman_show_partitions
from source
pg_performance_baseline
from source
pg_pgcrypto_create_extension
from source
pg_pgcrypto_crypt
from source
pg_pgcrypto_decrypt
from source
pg_pgcrypto_encrypt
from source
pg_pgcrypto_gen_random_bytes
from source
pg_pgcrypto_gen_random_uuid
from source
pg_pgcrypto_gen_salt
from source
pg_pgcrypto_hash
from source
pg_pgcrypto_hmac
from source
pg_point_in_polygon
from source
pg_postgis_create_extension
from source
pg_query_plan_compare
from source
pg_query_plan_stats
from source
pg_read_query
from source
pg_recovery_status
from source
pg_regexp_match
from source
pg_reindex
from source
pg_reload_conf
from source
pg_replication_status
from source
pg_reset_stats
from source
pg_restore_command
from source
pg_restore_validate
from source
pg_role_assign
from source
pg_role_attributes
from source
pg_role_create
from source
pg_role_drop
from source
pg_role_grant
from source
pg_role_grants
from source
pg_role_list
from source
pg_role_revoke
from source
pg_role_rls_enable
from source
pg_role_rls_policies
from source
pg_role_set
from source
pg_schema_snapshot
from source
pg_security_audit
from source
pg_security_encryption_status
from source
pg_security_firewall_rules
from source
pg_security_firewall_status
from source
pg_security_mask_data
from source
pg_security_password_validate
from source
pg_security_sensitive_tables
from source
pg_security_ssl_status
from source
pg_security_user_privileges
from source
pg_seq_scan_tables
from source
pg_server_version
from source
pg_set_config
from source
pg_show_settings
from source
pg_spatial_index
from source
pg_stat_activity
from source
pg_stats_correlation
from source
pg_stats_descriptive
from source
pg_stats_distinct
from source
pg_stats_distribution
from source
pg_stats_frequency
from source
pg_stats_hypothesis
from source
pg_stats_lag_lead
from source
pg_stats_moving_avg
from source
pg_stats_ntile
from source
pg_stats_outliers
from source
pg_stats_percentiles
from source
pg_stats_rank
from source
pg_stats_regression
from source
pg_stats_row_number
from source
pg_stats_running_total
from source
pg_stats_sampling
from source
pg_stats_summary
from source
pg_stat_statements
from source
pg_stats_time_series
from source
pg_stats_top_n
from source
pg_system_health
from source
pg_table_sizes
from source
pg_table_stats
from source
pg_terminate_backend
from source
pg_text_headline
from source
pg_text_normalize
from source
pg_text_rank
from source
pg_text_search
from source
pg_text_search_config
from source
pg_text_sentiment
from source
pg_text_to_query
from source
pg_text_to_vector
from source
pg_topological_sort
from source
pg_transaction_begin
from source
pg_transaction_commit
from source
pg_transaction_execute
from source
pg_transaction_release
from source
pg_transaction_rollback
from source
pg_transaction_rollback_to
from source
pg_transaction_savepoint
from source
pg_transaction_status
from source
pg_trigram_similarity
from source
pg_truncate
from source
pg_unused_indexes
from source
pg_upsert
from source
pg_uptime
from source
pg_user_roles
from source
pg_vacuum
from source
pg_vacuum_analyze
from source
pg_vacuum_stats
from source
pg_vector_add_column
from source
pg_vector_aggregate
from source
pg_vector_batch_insert
from source
pg_vector_cluster
from source
pg_vector_create_extension
from source
pg_vector_create_index
from source
pg_vector_dimension_reduce
from source
pg_vector_distance
from source
pg_vector_embed
from source
pg_vector_index_optimize
from source
pg_vector_insert
from source
pg_vector_normalize
from source
pg_vector_performance
from source
pg_vector_search
from source
pg_vector_validate
from source
pg_write_query
from source