{"name":"io.github.mittalpk/pgvector","slug":"mittalpk-pgvector","title":"pgvector","description":"Similarity search, hybrid search, and index management for pgvector-backed PostgreSQL tables","url":"https://mcp.market/server/mittalpk-pgvector","rating":null,"grade":"B","score":78,"certified":false,"status":"active","category":"search","tags":["search"],"presence":{"score":16,"stars":0,"forks":0,"downloads_week":14,"last_push_at":"2026-07-21T18:35:31.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"pypi","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/mittalpk/mcp-server-pgvector","website":null,"version":"0.1.0","remotes":[],"packages":[{"registryType":"pypi","identifier":"mcp-server-pgvector","version":"0.1.0","transport":{"type":"stdio"},"environmentVariables":[{"description":"PostgreSQL connection string, e.g. postgresql://user:password@host:5432/dbname","isRequired":true,"format":"string","isSecret":true,"name":"DATABASE_URL"},{"description":"Set to 'true' to disable upsert_embedding and create_vector_index","format":"string","name":"MCP_PGVECTOR_READ_ONLY"}]}],"tools":[{"name":"create_vector_index","description":"Create an HNSW or IVFFlat approximate-nearest-neighbor index on a vector column.","write_action":true,"price_micros":0,"input_schema":null},{"name":"describe_vector_table","description":"Get columns, indexes, and an approximate row count for a table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"explain_similarity_query","description":"Run EXPLAIN ANALYZE on a similarity query to confirm an ANN index is used.","write_action":true,"price_micros":0,"input_schema":null},{"name":"hybrid_search","description":"Rank rows by a weighted blend of vector similarity and Postgres full-text search.","write_action":false,"price_micros":0,"input_schema":null},{"name":"list_vector_tables","description":"List every column of type `vector` in the database, with its table and dimensionality.","write_action":false,"price_micros":0,"input_schema":null},{"name":"similarity_search","description":"Find the k nearest neighbors to a query embedding.","write_action":false,"price_micros":0,"input_schema":null},{"name":"upsert_embedding","description":"Insert a row or update it in place if `id_value` already exists (upsert).","write_action":true,"price_micros":0,"input_schema":null}],"scan":{"score":78,"grade":"B","scanned_at":"2026-09-25T17:21:57.470Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-25T17:21:57.219Z","components":{"code":{"score":25,"max":25,"notes":["5 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":12,"max":15,"notes":["last push 66 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"pypi","identifier":"mcp-server-pgvector","version":"0.1.0","found":true,"weeklyDownloads":14,"license":"MIT","dependencyCount":3,"publishedAt":"2026-07-21T18:46:01.521025Z","repositoryUrl":"https://github.com/mittalpk/mcp-server-pgvector"}],"repo":{"found":true,"owner":"mittalpk","repo":"mcp-server-pgvector","archived":false,"pushedAt":"2026-07-21T18:35:31Z","stars":0,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/46550971?v=4","ownerCreatedAt":"2019-01-10T04:18:22Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/46550971?v=4&s=128","source":"github"},"presence":{"stars":0,"forks":0,"downloadsWeek":14,"license":"MIT","lastPushAt":"2026-07-21T18:35:31.000Z","score":16}}}},"grade_history":[],"reviews":[]}