Pricing

Pay per usage

Go to Store

PGVector Integration

Try for free

Developed by

Apify

This integration transfers data from Apify Actors to a Postgres SQL database (with PGVector extension).

4.6 (5)

Pricing

Pay per usage

Monthly users

Runs succeeded

33%

Response time

19 hours

Last modified

3 days ago

Integrations

Open source

You can access the PGVector Integration programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1# Start Server-Sent Events (SSE) session and keep it running
2curl "https://actors-mcp-server.apify.actor/sse?token=<YOUR_API_TOKEN>&actors=apify/pgvector-integration"
3
4# Session id example output:
5# event: endpoint
6# data: /message?sessionId=9d820491-38d4-4c7d-bb6a-3b7dc542f1fa

Using PGVector Integration via Model Context Protocol (MCP) server

MCP server lets you use PGVector Integration within your AI workflows. Send API requests to trigger actions and receive real-time results. Take the received sessionId and use it to communicate with the MCP server. The message starts the PGVector Integration Actor with the provided input.

1curl -X POST "https://actors-mcp-server.apify.actor/message?token=<YOUR_API_TOKEN>&session_id=<SESSION_ID>" -H "Content-Type: application/json" -d '{
2  "jsonrpc": "2.0",
3  "id": 1,
4  "method": "tools/call",
5  "params": {
6    "arguments": {
7      "datasetFields": [
8            "text"
9      ],
10      "dataUpdatesStrategy": "deltaUpdates",
11      "dataUpdatesPrimaryDatasetFields": [
12            "url"
13      ],
14      "deltaUpdatesPrimaryDatasetFields": [
15            "url"
16      ]
17},
18    "name": "apify/pgvector-integration"
19  }
20}'

The response should be: Accepted. You should received response via SSE (JSON) as:

1event: message
2data: {
3  "result": {
4    "content": [
5      {
6        "type": "text",
7        "text": "ACTOR_RESPONSE"
8      }
9    ]
10  }
11}

Configure local MCP Server via standard input/output for PGVector Integration

You can connect to the MCP Server using clients like ClaudeDesktop and LibreChat or build your own. The server can run both locally and remotely, giving you full flexibility. Set up the server in the client configuration as follows:

1{
2  "mcpServers": {
3    "actors-mcp-server": {
4      "command": "npx",
5      "args": [
6        "-y",
7        "@apify/actors-mcp-server",
8        "--actors",
9        "apify/pgvector-integration"
10      ],
11      "env": {
12        "APIFY_TOKEN": "<YOUR_API_TOKEN>"
13      }
14    }
15  }
16}

You can further access the MCP client through the Tester MCP Client, a chat user interface to interact with the server.

To get started, check out the documentation and example clients. If you are interested in learning more about our MCP server, check out our blog post.

Pricing

Pricing model

Pay per usage

This Actor is paid per platform usage. The Actor is free to use, and you only pay for the Apify platform usage.

WCC Pinecone Integration

tri_angle/wcc-pinecone-integration

Crawl any website and store its content in your Pinecone vector database. Enhance the accuracy and reliability of your own AI Assistant with facts fetched from external sources or connect this integration to our Pinecone GPT Chatbot assistant available in Apify Store.

Tri⟁angle

113

Actors MCP Server

apify/actors-mcp-server

Connect Apify Actors to AI applications (AI Agents) using Anthropic's Model Context Protocol (MCP). This MCP server provides integration of any Apify Actor through the MCP framework.

Apify

484

Pinecone Integration

apify/pinecone-integration

This integration transfers data from Apify Actors to a Pinecone and is a good starting point for a question-answering, search, or RAG use case.

Apify

309

Medium Publications Search Scraper

easyapi/medium-publications-search-scraper

Scrape Medium publications by keywords - Extract publication details including name, description, URL and avatar from Medium's search results efficiently and reliably.

EasyApi

OpenSearch Integration

apify/opensearch-integration

Transfer data from Apify Actors to Amazon OpenSearch Service. This Actor is a good starting point for building question-answering systems, search functionality, or Retrieval-Augmented Generation (RAG) use cases.

Apify

Pinecone GPT Chatbot

tri_angle/pinecone-gpt-chatbot

Pinecone GPT Chatbot combines OpenAI's GPT models with Pinecone's database to generate insightful responses. Its interactive chatbot interface presents precise and comprehensive answers to user queries. Benefit from semantic understanding, efficient workflows, and enriched knowledge integration!

Tri⟁angle

BBC Scraper

theo/bbc-scraper

Scrape news data from bbc.com with this unofficial API. Extract articles, monitor their popularity and performance and automate the fight against fake news. Filter the results by authors, topics, categories, or publication dates. Preview or download the results in your preferred format.

Theo Vasilis

Twitter/X Video Downloader

easyapi/twitter-x-video-downloader

Easily download high-quality videos from Twitter/X. With batch downloading capabilities and high-speed scraping, you can effortlessly enhance your video collection! 🐦

EasyApi

Naked Domains Analyzer

jancurn/analyze-domains

Crawls and downloads web pages running on a list of provided naked domains e.g. "example.com". The actor stores HTML snapshot, screenshot, text body, and HTTP response headers of all the pages. It also extracts email addresses, phones, social handles for Facebook, Twitter, LinkedIn, and Instagram.