
PostgreSQL
Connects to PostgreSQL databases to execute SQL queries, manage tables, and inspect database schemas. Supports prepared statements with multiple parameter styles.
9683 views4Local (stdio)
What it does
- Execute SELECT queries with parameters
- Run INSERT, UPDATE, DELETE operations
- List database schemas and tables
- Inspect table structures and columns
- Use prepared statements for security
- Connect to remote PostgreSQL instances
Best for
Developers building database-driven applicationsData analysts querying PostgreSQL databasesDatabase administrators managing schemasApplications needing secure parameterized queries
Supports both PostgreSQL ($1) and MySQL (?) parameter stylesBuilt-in prepared statement security