-
Notifications
You must be signed in to change notification settings - Fork 1.1k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We鈥檒l occasionally send you account related emails.
Already on GitHub? Sign in to your account
how to see an sql query #1255
Comments
Hello, @sakoser! I'm here to assist you with any bugs, questions, or contributions you may have while we wait for a human maintainer. Let's squash those bugs together! 馃 Yes, you can receive an SQL query directly when connecting via the API without using a prompt. The Here is the relevant code snippet: def execute_direct_sql_query(self, sql_query):
if not self._is_sql_query_safe(sql_query):
raise MaliciousQueryError("Malicious query is generated in code")
return pd.read_sql(sql_query, self._connection) Additionally, you can configure the import os
from pandasai import Agent
from pandasai.connectors import PostgreSQLConnector
# With a PostgreSQL database
order = PostgreSQLConnector(
config={
"host": "localhost",
"port": 5432,
"database": "testdb",
"username": "postgres",
"password": "123456",
"table": "orders",
}
)
order_details = PostgreSQLConnector(
config={
"host": "localhost",
"port": 5432,
"database": "testdb",
"username": "postgres",
"password": "123456",
"table": "order_details",
}
)
products = PostgreSQLConnector(
config={
"host": "localhost",
"port": 5432,
"database": "testdb",
"username": "postgres",
"password": "123456",
"table": "products",
}
)
# By default, unless you choose a different LLM, it will use BambooLLM.
# You can get your free API key signing up at https://pandabi.ai (you can also configure it in your .env file)
os.environ["PANDASAI_API_KEY"] = "your-api-key"
agent = Agent(
[order, products, order_details],
config={"direct_sql": True},
)
response = agent.chat("return orders with count of distinct products")
print(response) This example demonstrates how to set up the |
System Info
Good afternoon. Can you tell me if I can receive an SQL query when I connect via the API without using promt?
馃悰 Describe the bug
The text was updated successfully, but these errors were encountered: