Insert data through a script directly in the db

Yes its possible but why go over the trouble when you can use the native functions like wp_insert_post that will take care of the interaction with the database.

If you are still looking to do it directly by $wpdb then the post data is saved in the posts table, the meta data for posts is saved in the postmeta table.