SQLDatabase

This component lets Nappai connect to your SQL database, allowing you to use your database information in your automations. Think of it as a bridge between Nappai and your data.

Relationship with SQL Databases

This component connects to your SQL database (like PostgreSQL, MySQL, etc.) using standard connection details. It allows Nappai to retrieve and potentially update information stored within your database.

Inputs

User: Your database username. This is required.
Password: Your database password. This is required. Remember to keep this secure!
Hostname: The address of your database server (e.g., mydb.example.com). This is required.
Port: The port number your database server is listening on (usually 5432 for PostgreSQL, but it might be different for your database). If you don’t know, leave it as the default (5432).
Database: The name of the database you want to connect to (e.g., mydatabase).
Table to use: (Optional) The specific table within the database you want to work with. If you leave this blank, Nappai will connect to the database but won’t automatically select a specific table.

Outputs

SQLDatabase: This output provides Nappai with a connection to your specified database and table (if provided). Other components can then use this connection to interact with your data.
URI Database string: This output shows the complete connection string used to connect to your database. This is helpful for troubleshooting.

Usage Example

Let’s say you want to use data from a table called “Customers” in your “Sales” database. You would configure the SQLDatabase component with:

User: your_username
Password: your_password
Hostname: your_database_server_address
Port: 5432 (or your database’s port)
Database: Sales
Table to use: Customers

After configuring these inputs, Nappai will establish a connection, and the “SQLDatabase” output will be available for other components to use.

Templates

[This section will be populated with a list of templates once the component is integrated into the Nappai system.]

[This section will be populated with links to other related components once they are available.]

Tips and Best Practices

Security: Never hardcode your database password directly into the Nappai dashboard. Consider using environment variables or secure configuration methods for sensitive information.
Error Handling: If you encounter connection problems, double-check your username, password, hostname, port, and database name. The “URI Database string” output can help identify the issue.
Testing: Test your connection settings thoroughly before using this component in critical automations.

Security Considerations

Password Protection: Protect your database credentials. Do not share them unnecessarily.
Access Control: Ensure your database has appropriate access controls to prevent unauthorized access.
Input Validation: While Nappai handles some input validation, always review the inputs to prevent SQL injection vulnerabilities. Avoid directly using user-supplied data in SQL queries without proper sanitization.