Sf Datacloud Connect
Generate Salesforce Data Cloud connector JSON for Heroku Postgres ingress or Ingest API objects with correct fields and credentials placeholders.
Overview
Sf-datacloud-connect is an agent skill for the Build phase that supplies Salesforce Data Cloud connector and Ingest API schema JSON templates for Postgres ingress and API ingestion.
Install
npx skills add https://github.com/jaganpro/sf-skills --skill sf-datacloud-connectWhat is this skill?
- HerokuPostgres connector template with UsernamePasswordAuthentication credentials
- jdbc_connection_url and DATABASE parameter slots for ingress wiring
- IngestApi connector skeleton with label and API name
- IngestApi schema JSON with Text, DateTime, and Number field examples
- Points to sf-datacloud family CREDITS and UPSTREAM docs for maintenance
- Includes HerokuPostgres connector JSON with 3 credential params and 2 connection parameters
- Sample IngestApi schema defines 4 fields: Id, Name, Timestamp, Value
Adoption & trust: 870 installs on skills.sh; 418 GitHub stars; 3/3 security scanners passed (skills.sh audits).
What problem does it solve?
You need valid Data Cloud connector payloads for Heroku Postgres or Ingest API but keep mis-typing credential blocks or schema field structures.
Who is it for?
Salesforce implementers and indie consultants automating Data Cloud connector bootstrap with an coding agent.
Skip if: Builders without a Data Cloud license or those only querying CRM core objects with standard Salesforce APIs.
When should I use this skill?
You are creating or editing a Salesforce Data Cloud connector for Heroku Postgres ingress or defining an Ingest API connector and object schema.
What do I get? / Deliverables
You produce structured connector and schema JSON with placeholder credentials and field types ready to adapt in your Data Cloud org.
- HerokuPostgres connector JSON draft
- IngestApi connector and schema JSON draft
Recommended Skills
Journey fit
Data Cloud connections are implemented when you integrate external systems into the Salesforce data platform during product build. Connector definitions, JDBC parameters, and Ingest API schemas are integration artifacts, not frontend or launch work.
How it compares
Template skill for connector JSON—not a live MCP server or turnkey ETL runtime.
Common Questions / FAQ
Who is sf-datacloud-connect for?
Developers and architects on Salesforce Data Cloud projects who want agent-assisted, consistent connector definitions for Postgres ingress or Ingest API sources.
When should I use sf-datacloud-connect?
In Build integrations while defining Data Cloud connections to Heroku Postgres or standing up Ingest API objects before activation and mapping in the org.
Is sf-datacloud-connect safe to install?
Templates reference credentials placeholders only; do not commit real passwords. Review the Security Audits panel on this Prism page before installing from third-party repos.
SKILL.md
READMESKILL.md - Sf Datacloud Connect
# Credits & Acknowledgments Primary contributor: **Gnanasekaran Thoppae** This skill is part of the `sf-datacloud-*` family. Shared attribution, upstream source mapping, and maintenance notes live in: - [../sf-datacloud/CREDITS.md](../sf-datacloud/CREDITS.md) - [../sf-datacloud/UPSTREAM.md](../sf-datacloud/UPSTREAM.md) { "connectorType": "HerokuPostgres", "label": "My Heroku DB", "name": "My_Heroku_DB", "method": "Ingress", "credentials": [ { "paramName": "credentialType", "value": "UsernamePasswordAuthentication" }, { "paramName": "user", "value": "<HEROKU_DB_USER>" }, { "paramName": "password", "value": "<HEROKU_DB_PASSWORD>" } ], "parameters": [ { "paramName": "jdbc_connection_url", "value": "<HOST>:<PORT>" }, { "paramName": "DATABASE", "value": "<DATABASE_NAME>" } ] } { "connectorType": "IngestApi", "label": "<CONNECTOR_LABEL>", "name": "<CONNECTOR_NAME>" } { "schemas": [ { "label": "<OBJECT_NAME>", "name": "<OBJECT_NAME>", "schemaType": "IngestApi", "fields": [ { "name": "Id", "label": "Id", "dataType": "Text" }, { "name": "Name", "label": "Name", "dataType": "Text" }, { "name": "Timestamp", "label": "Timestamp", "dataType": "DateTime" }, { "name": "Value", "label": "Value", "dataType": "Number" } ] } ] } { "connectorType": "REDSHIFT", "label": "My Redshift", "name": "My_Redshift", "method": "Ingress", "credentials": [ { "paramName": "authenticationOption", "value": "usernameAndPassword" }, { "paramName": "username", "value": "<REDSHIFT_USER>" }, { "paramName": "password", "value": "<REDSHIFT_PASSWORD>" } ], "parameters": [ { "paramName": "url", "value": "<HOST>:<PORT>" }, { "paramName": "database", "value": "<DATABASE_NAME>" }, { "paramName": "hasPrivateNetworkRoute", "value": "false" } ] } { "connectorType": "SPUnstructuredDocument", "label": "My SharePoint Docs", "name": "My_SharePoint_Docs", "method": "Ingress", "credentials": [ { "paramName": "clientId", "value": "<AZURE_APP_CLIENT_ID>" }, { "paramName": "clientSecret", "value": "<AZURE_APP_CLIENT_SECRET>" }, { "paramName": "tokenEndpoint", "value": "https://login.microsoftonline.com/<AZURE_TENANT_ID>/oauth2/v2.0/token" } ] } { "connectorType": "SNOWFLAKE", "label": "Snowflake Demo", "name": "Snowflake_Demo", "method": "Ingress", "credentials": [ { "paramName": "credentialType", "value": "KeyPairAuthentication" }, { "paramName": "user", "value": "<SNOWFLAKE_USERNAME>" }, { "paramName": "privateKey", "value": "<YOUR_PRIVATE_KEY_WITHOUT_BEGIN_END_HEADERS>" } ], "parameters": [ { "paramName": "accountUrl", "value": "https://<ORG_ID>-<ACCOUNT_ID>.snowflakecomputing.com" }, { "paramName": "database", "value": "<DATABASE_NAME>" }, { "paramName": "warehouse", "value": "<WAREHOUSE_NAME>" }, { "paramName": "region", "value": "<AWS_REGION>" }, { "paramName": "hasPrivateNetworkRoute", "value": "false" } ] } MIT License Copyright (c) 2024-2025 Jag Valaiyapathy Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE