AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents
TypeScript ai-agentai-agent-toolsai-agentsai-agents-frameworkmcpmcp-servermcp-toolsmcpsn8n-alternativeno-code-automationworkflowworkflow-automationworkflows
import {
PieceAuth,
Property,
StaticPropsValue,
} from '@activepieces/pieces-framework';
import { OracleRunnerError, runnerPool } from './runner-pool';
import type { RunnerAuth } from './runner-protocol';
export const oracleDbAuth = PieceAuth.CustomAuth({
description: `Connect to Oracle Database using either Service Name (host/port/service) or a full connection string.`,
required: true,
props: {
connectionType: Property.StaticDropdown({
displayName: 'Connection Type',
description: 'How you want to connect',
required: true,
options: {
options: [
{ label: 'Service Name', value: 'serviceName' },
{ label: 'Connection String', value: 'connectionString' },
],
},
defaultValue: 'serviceName',
}),
host: Property.ShortText({
displayName: 'Host',
description: 'Database server hostname or IP',
required: false,
}),
port: Property.Number({
displayName: 'Port',
description: 'Database port',
required: false,
defaultValue: 1521,
}),
serviceName: Property.ShortText({
displayName: 'Service Name',
description: 'Oracle service name',
required: false,
}),
connectionString: Property.LongText({
displayName: 'Connection String',
description: 'Full connection string (e.g., host:port/serviceName)',
required: false,
}),
user: Property.ShortText({
displayName: 'Username',
required: true,
}),
password: PieceAuth.SecretText({
displayName: 'Password',
required: true,
}),
thickMode: Property.Checkbox({
displayName: 'Thick Mode',
description:
'Enable to support older Oracle Database versions (11g, 10g password verifiers). ' +
'Oracle Instant Client will be downloaded and installed automatically if not already present.',
required: false,
defaultValue: false,
}),
},
validate: async ({ auth }) => {
const typedAuth = auth as StaticPropsValue<(typeof oracleDbAuth)['props']>;
const logs: string[] = [];
if (typedAuth.connectionType === 'serviceName') {
if (!typedAuth.host || !typedAuth.port || !typedAuth.serviceName) {
return {
valid: false,
error:
'Host, Port, and Service Name are required for this connection type.',
};
}
logs.push(
`[oracle] Connection type: serviceName → ${typedAuth.host}:${typedAuth.port}/${typedAuth.serviceName}`
);
} else {
if (!typedAuth.connectionString) {
return {
valid: false,
error: 'Connection String is required for this connection type.',
};
}
logs.push(
`[oracle] Connection type: connectionString → ${typedAuth.connectionString.replace(
/\/\/[^:]+:[^@]+@/,
'//***:***@'
)}`
);
}
const runnerAuth: RunnerAuth = {
connectionType: typedAuth.connectionType,
host: typedAuth.host,
port: typedAuth.port,
serviceName: typedAuth.serviceName,
connectionString: typedAuth.connectionString,
user: typedAuth.user,
password: typedAuth.password,
thickMode: typedAuth.thickMode === true,
};
logs.push(`[oracle] Thick mode: ${runnerAuth.thickMode}`);
try {
const { runner, initLogs } = await runnerPool.acquire(
runnerAuth.thickMode ? 'thick' : 'thin'
);
logs.push(...initLogs);
const { logs: invokeLogs } = await runner.invoke<{ valid: boolean }>({
cmd: 'validate',
auth: runnerAuth,
});
if (invokeLogs) logs.push(...invokeLogs);
logs.push('[oracle] Connection established successfully.');
console.log(logs.join('\n'));
return { valid: true };
} catch (e) {
if (e instanceof OracleRunnerError && e.logs) logs.push(...e.logs);
logs.push(
`[oracle] Error: ${(e as Error)?.message ?? 'Unknown error'}`
);
return {
valid: false,
error: `Connection failed. Debug log:\n${logs.join('\n')}`,
};
}
},
});
export type OracleDbAuth = StaticPropsValue<typeof oracleDbAuth.props>;