n8n-nodes-ldapquery

A custom n8n node for querying and managing LDAP/Active Directory servers with AI-powered natural language query support.

Features

• 🔍 LDAP Query Operations: Search users, groups, and other objects in your LDAP directory
• 🤖 AI-Powered Natural Language Queries: Convert plain English queries to LDAP filters using OpenAI
• 👤 User Creation: Create new Active Directory users with comprehensive attributes
• 🔐 Secure Authentication: Support for bind DN authentication with optional SSL/TLS
• 📊 Pagination Support: Handle large result sets with configurable page sizes
• 🎛️ Flexible Configuration: Extensive options for user creation and query customization

Installation

Option 1: Install from npm (Recommended)

npm install n8n-nodes-ldapquery

Option 2: Manual Installation

1. Clone this repository
2. Build the project:

   npm install
   npm run build

3. Copy the dist folder to your n8n custom nodes directory

Option 3: n8n Community Nodes

1. Go to Settings > Community Nodes in your n8n instance
2. Click Install a community node
3. Enter: n8n-nodes-ldapquery
4. Click Install

Configuration

LDAP Credentials

Before using this node, you need to configure LDAP credentials:

1. Go to Credentials in your n8n instance
2. Click Create New
3. Select LDAP Credentials
4. Fill in:
   • LDAP Server URL: ldap://your-server.com:389 or ldaps://your-server.com:636
   • Bind DN: CN=service-account,OU=Users,DC=company,DC=com
   • Bind Password: Your service account password

OpenAI API (Optional)

For natural language query support:

1. Create OpenAI API credentials
2. Add your OpenAI API key

Usage

Query Operations

Natural Language Queries

Find all users in the Sales department
Show me John Smith's contact information
List all disabled accounts
Find users with manager email [email protected]

Manual LDAP Filters

(objectClass=person)
(&(objectClass=user)(department=Sales))
(&(cn=John*)(mail=*))
(userAccountControl:1.2.840.113556.1.4.803:=2)

User Creation

Create new Active Directory users with:

• Required Fields: Full Name, Last Name, First Name, Username, UPN, Password, Target OU
• Optional Fields: Title, Department, Email, Phone, Manager, Company, Office

Examples

Basic User Query

{
  "operation": "query",
  "searchBase": "DC=company,DC=com",
  "searchFilter": "(objectClass=person)",
  "attributes": "cn,mail,department",
  "pageSize": 100
}

AI-Powered Query

{
  "operation": "query",
  "nlQuery": "Find all users in IT department",
  "searchBase": "DC=company,DC=com",
  "attributes": "cn,mail,title,department"
}

Create New User

{
  "operation": "create",
  "newCn": "John Doe",
  "newSn": "Doe",
  "newGivenName": "John",
  "newUsername": "jdoe",
  "newUpn": "[email protected]",
  "newPassword": "SecurePassword123!",
  "newOu": "OU=Users,DC=company,DC=com",
  "options": {
    "title": "Software Engineer",
    "department": "IT",
    "email": "[email protected]",
    "phoneNumber": "+1-555-0123"
  }
}

Node Properties

Query Operation

| Property | Type | Description | |----------|------|-------------| | Natural Language Query | string | Plain English query (requires OpenAI API) | | Manual Search Filter | string | LDAP filter syntax | | Search Base | string | Base DN for search | | Attributes | string | Comma-separated list of attributes | | Page Size | number | Maximum results per page | | AI System Prompt | string | Custom prompt for AI query conversion |

Create User Operation

| Property | Type | Description | |----------|------|-------------| | Full Name | string | Complete name (CN) | | Last Name | string | Surname (sn) | | First Name | string | Given name | | Username | string | sAMAccountName | | UPN | string | User Principal Name | | Password | string | User password | | Target OU | string | Organizational Unit DN | | Options | collection | Additional user attributes |

Security Considerations

• Use service accounts with minimal required permissions
• Enable SSL/TLS for production environments
• Store credentials securely in n8n's credential system
• Regularly rotate service account passwords
• Monitor LDAP access logs

Troubleshooting

Common Issues

1. Connection Timeout

   • Check LDAP server URL and port
   • Verify network connectivity
   • Check firewall settings

2. Authentication Failed

   • Verify Bind DN format
   • Check service account password
   • Ensure account has necessary permissions

3. SSL/TLS Errors

   • Use ldaps:// for secure connections
   • Enable "Disable Certificate Validation" for testing only
   • Verify certificate chain

4. Search Returns No Results

   • Check search base DN
   • Verify LDAP filter syntax
   • Ensure attributes exist in schema

Debug Mode

Enable debug logging in n8n to see detailed LDAP operations:

N8N_LOG_LEVEL=debug npm start

Development

Building from Source

git clone https://github.com/widjis/LdapQuery.git
cd LdapQuery
npm install
npm run build

Project Structure

src/
├── LdapQuery.node.ts          # Main node implementation
├── credentials/
│   └── LdapCredentials.credentials.ts  # Credential definition
└── lib/
    └── ldapService.ts          # LDAP service functions

Dependencies

• ldapjs: LDAP client library
• n8n-workflow: n8n workflow types and utilities
• axios: HTTP client for OpenAI API calls

Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Add tests if applicable
5. Submit a pull request

License

MIT License - see LICENSE file for details

Support

For issues and questions:

• Create an issue on GitHub
• Check the n8n community forum
• Review the troubleshooting section above

Changelog

v1.0.0

• Initial release
• LDAP query and user creation operations
• AI-powered natural language queries
• Comprehensive user attribute support
• SSL/TLS support with certificate validation options